Changed database and report doesn't work.

[jlbsloan]

I have Crystal reports 8. I have 2 SQL databases that are identical in structure, just have different names and data on the same server. The report works fine on one and when I either set the location of the tables or change the database driver the report acts like it locks up. I have 3 subreports and I get a result with three pages with the report header but the subreport headers don't even print like they do when they don't return any records.The database verification is OK and I can browse the fields for data just fine.I have tried remarking out all of the record selection criteria but that did not help.The last version of this report worked fine, I just made a few minor changes to some of the parameters making them multivalued to filter the records by, so I know that the report will work with the other database. Do you have any ideas on how to resolve this problem? Perhaps I am overlooking something when I am changing the database this time that I did not last time.
Thanks in advance for any help offered,
Jerry

 

[dcm]

jlbsloan: Try setting the location of the subreports as separate reports and testing that you get the correct response before re-importing them back into the main report David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner