Troubleshooting help, new to Crystal Reports

[cocopud]

I have just started using crystal reports and was wondering if anyone had any suggestions on how to troubleshoot report problems. Is there anyway to step through the report to see what is happening. I have two reports, one is a summary and the other is a detailed report which is supposed to be the same as the summary, but with a subreport with more detail. However, the totals in the two reports are not the same and they should be.

I'm not sure where to start to see what is happening. I have been looking through both reports I export the report definitions for both, but one has 18 pages and the other has 44, and I'm not sure if this will be helpful. When I start looking at the reports one has 2 report headers and ther other has 3 report headers. The 2 header report seems to be using both headers, one on every other page, but the other only appears to be using two of the headers.

Any suggestions on how to start looking into these problem to narrow it down or to see how the report is running would be helpful

 

[sim133]

See the sql statement in both report. Run the reports, then go to
Database --> Show SQL Query

 

[cocopud]

Thank you, but that does not help much. It is only one line and it is the same for both reports and only shows the parameters that I chose when I ran the report

 

[lbass]

I would check to make sure the record selection formulas are the same, and that the table joins are the same in the database expert. Then examine the totals to see if they are both derived in the same way (inserted summaries, running totals, etc.). I wonder about the subreport--if there are shared variables that contribute to the report total, the problem might be there.

Finally, it is often helpful to take a look at the detail sections of reports to see exactly what date is being returned--so you might want to look at detail rows in the summary report and compare to the other report.

Not much more help to be provided without seeing the actual data.

-LB

 

[Madawc]

If none of the earlier suggestions work, use 'Save As' to get test versions of the two reports. Adapt them to show as many details as possible. Notably which records are being included and how the various totals accumulate.

As far as I know, you can't 'debug' Crystal by looking at the internal workings. Crystal has a 'flow', a fixed cycle that you have to slot your own code into. It isn't a full programing language: that's the price you pay for a software tool that can be used to produced a nice-looking report very quickly.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10