I'm testing out a Java data source for a subreport, but am finding that Crystal RAS makes repetitive calls to the data source, one for each record in the main report. This seems inefficient since the since the inputs and return of the subreport's Java data source are identical for each record of the main report.
My question is ... is there a way to bulid either the Crystal Report or the Java data source so that the subreport's Java data source is called at most once for the report execution. This would be far more efficient since the inputs and return of the subreport's Java data source are identical for each record of the main report.
If an example helps, imagine a subreport where years are rendered in the main report and the quarters of the year are rendered for each year in the subreport. The 'years' data source returns 2005 and 2006. And the 'quarters' data source returs Q1 2005, Q2 2005, Q3 2005, Q4 2005, Q1 2006, Q2 2006, Q3 2006, Q4 2006. What I've found is that for years, 2005 and 2006, Crystal RAS makes two calls to the 'quarters' data source and the 'quarters' data source, without the context of the year its being called for, returns all 8 quarters both times. Although Crystal RAS does group and render the data appropriately, I don't understand why Crystal RAS needs to call the 'quarters' data source twice since a single call to the subreport data source returns all the data (all 8 quarters) necessary for the report to be rendered.
I hope this makes sense.
Any assistance would be appreciated.