Crystal Reports 11 - How do I fix Datasource for subreport?

[Former Member]

Hi.  We are still using CR11.  When I am in the IDE and run the Print Preview, I see a message that the table and database no longer exists and do I want to remove it from the report.  It is true, we often delete unused test databases.  Somehow, this subreport has accidentally been orphaned.

This report has about 25 subreports.  Is there a way to look at this report to determine which one is using a connection to the deleted database?

[former_member11696 · Accepted solution]

Hi Debbie,

Only way is to open each subreport, double click on it in Design mode, and then click on Set Location. And attempt to preview it.

Don

[Former Member · Accepted solution]

Hi.  I was hoping for a shortcut.  In the end, I did exactly as Don suggested.  With that many subreports, it was a hassle, but I finally tracked it down.

I had been under the mistaken belief that the subreports used whatever connection the main report had.  Learn something new every day.

[former_member11696 · Accepted solution]

Hi Debbie,

Correct, CR assumes the connection info does not change but if it does CR 11 does not "Propagate" the connection info, we used to but that caused problems also, Subreports are typically used for a second data source so setting it to the same source as the main report is wrong...

If you use the SDK in an application you could write a program to test the subreport connections and if it fails then obviously you found the problem.

Also, you can upgrade to CR 11.5 SP 4 and fix pack 6 for free. Use your CR 11 Keycode to install.

http://downloads.businessobjects.com/akdlm/crystalreports/crxir2_sp4_full_bld_0-20008684.exe

http://downloads.businessobjects.com/akdlm/crystalreports/CRYSTALREPORTS06_0-20008684.EXE

Don