Has your data connection code changed since you posted it? If so, can you post it again?
>Additional Info: I tracked down part of my problem, I am just hoping someone else has come across this issue and has a fix. Originally, I was running this report off of an ODBC connection to roughly five tables. The problem I was encountering was that the RDC was taking an extraordinary amount of time to run the report. After trying to find a way to speed up the process without success, I decided to forgo the ODBC connection and instead, process all the calculations in FoxPro, and export two tables with all the required information preformatted. I took the original RPT, removed the ODBC tables, added the FOX2X tables and made some minor tweaks to the design so that it all worked off the new tables.
>
>Now when I run in the Crystal Application, everything works great. The RDC however complains about a Logon Failure. Upon stepping through the code, I found that the
.Database.Tables collection is STILL reporting the ODBC tables. I have no clue where it is getting this information from. I checked the RPT file setting several times, and I see no references to the ODBC tables. Why do these reference still exist in the Collection? How do I get rid of them? Please help....thanks in advanced for any help that can be offered.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer