Report with Totals Page Question

rbuser

I have a report that prints lines with various amounts on it.

For example

Parcel Number Amount1 Amount2 Amount3

At the end of the report (in the summary section I think), i have a sub
report that is a totals page based on the example above. I filter form
is displayed asking if the user wants, details, totals or both. If they
select totals only, I turn the detail section of the report to
invisible. Detail only makes the subreport (with the totals invisible).

However, if the user selects totals only, the report still has to
process the detail section (even though its invisible). I assume this
is just the way the report writer works. Is there a way to either not
calculate the detail section (via rap?) when the user selects totals
only or have some kind of progress dialog during the detail section
(even though the detail section is invisible), so that the user will not
think the report is locked up. Currently, if the detail section takes 2
minutes to preview, the preview form looks like its locked up for 2
minutes until it gets to the subreport.

THanks

nicocizik

Hi Jeff,

It is necessary for the report engine to traverse all the records if you are
calculating a sum within ReportBuilder. Setting the Cancel Dialog
(ShowCancelDialog property) to True should give your users a status message
while the report is generating.

How many records are being traversed? 2 minutes for a single report seems
rather long. Are you generating a two pass report?

One option you might consider is passing the calculation process over to the
Database. Try creating a query with calculated fields for Amount1, Amount2,
and Amount3 and just display these values in the subreport when needed.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

The subreport calculations are done on the database. The problem is,
the detail report could have for example 10,000 pages and the
ShowCancelDialog property is true.

nicocizik

Hi Jeff,

One option you might try is simply disconnecting the pipeline from the main
report if the user does not want to view those records. This way only the
calculated data is retrieved.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

The main problem (I think) is. Even though the subreport with the
totals is done on the database, since the user has the option for
details, totals or both, and the totals page is at the end of the
report. Even if the user selects totals only, the report still has to
process the details page (even though its set to invisible). I could
not find a way to get a process dialog or not calculate the details page
if its invisible.

rbuser

That worked thanks (I should have thought of that).