Subreports and Grandtotals

rbuser

I am using the end user report writer.

I have a report with a subreport. The sub report has a DBcalc component on
the Summary Band that is totaling a column. I want to display the grand
total the sub report column on the main report Summary Band.

I can't seem to get it to work and I can't access the events of the
subreport.

Any ideas?

nicocizik

Isaac,

Below is a link to an example that shows how you should go about printing
the subreport total in the summary band of the main report.

http://www.digital-metaphors.com/tips/SubreportTotalsInMainSummary.zip

--

rbuser

Hi Nico, this example will not work for an end user report writer. Variables
that appear on different reports/subreports cannot be referenced in each
other's events.

The code did remind me to use a variable on the summary detail band simply
to get an event to update a global variable.

Thanks.

nicocizik

Isaac,

There is a way to accomplish this using RAP. Below is an example of how you
can keep track of a running total in RAP.

http://www.digital-metaphors.com/tips/MDRapRunningTotal.zip

--

rbuser

That worked perfectly.

I never thought of that. Neat trick.

Thanks Nico.