I have a report that contains 8 subreports. The main report has no datasource and is merely there to contain the subreports. Each subreport contains a simple record count (8 databases, each counted in one of the subreports). All 8 of the databases require a password.
When I refresh the report, CRXI quickly counts 0 records and completes, returning 8 blank subreports.
If I double click a subreport in Preview, I get promted to log on and Crystal reads the records and returns the correct count. Returning to the Main report Preview, I still see 8 blank subreports.
I have been through all of the setting I can find and can see nothing preventing the report from running correctly.
Any ideas anyone?
Incidentally, if I run the report in CR2008 (trial), it works perfectly.
Cheers,
Matt