Continue processing report when sub-report fails

[jontvr]

I'm running this on CE10, but the same issue applies to Crystal Reports designer when the report is run directly.

My report contains 12 identical sub-reports, but each has a different connection string pointing to geographically dispursed databases. The main report itself contains no data other than a heading. My problem is that the entire report fails if one or more of the sub-reports fails to connect to it's database. This can occur due to back-up and maintenance schedules in the different time zones. Is there anyway to get the report to complete and display the data that is was able to gather, and optionally display a status report in place of the missing sub-report(s)?

 

[Madawc]

Have the subreport return a value using a shared variable, if it runs OK. Put a section below the section containing the subreport, that says "SUBREPORT FAILED", and is suppressed if the expected value is returned.

To pass data back from a subreport, use a shared variable.

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved:={#TotSaved};
SumSaved

And to access it in the main report, create another formula field with

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved

Note that the shared variable is only available in the section after the section which contains the subreport.

Madawc Williams (East Anglia, UK)

 

[jontvr]

Thanks, but the core problem is the failure of the whole report if one of the sun-reports fails.

 

[Bobbber]

I see. Consider converting each sub report to an actual report. Then putting them all in a package. Set the package to not fail when one object fails.

Let me know if that helps!

Bob