How do I pass a subreport *group* total to main report?

[GitarJake]

Hello all,

How do I pass a subreport group total to main report?

I have this huge sales report that I just want totals from. All the data
is in several subreports that are grouped by sales people. The bean
counters don't care about the data, they just want totals and calculations
on totals.

How do I do this?

TIA

Jake

 

[Duane Hookom]

Why would you use subreports if you don't want to see them? Couldn't you
just calculate all the totals in a main report?

 

[GitarJake]

Hi Duane,

Well, I spoke unkindly of the bean counters. They do care about the data.
They just want to see the bottom line, up front. Or in this case on top.

Thanks,

Jake

 

[Duane Hookom]

You can reference the value of a text box from a subreport in the main
report using an expression like:
=srptControlName.Report.txtName

 

[GitarJake]

Hi Duane.

I'll try this in a bit but first another question:

If I have the following structure in a subreport, how would I get your
formula to show me all the group totals for each individual on the main
report? For instance, I need to see Individ 1 and Individ 2 subtotals on
the main report. Will =srptControlName.Report.txtName on the main report
show the totals for each individual?

Individ 1
Sale 1
Sale 2
Sale 3

Individ 1 Subtotal


Individ 2
Sale 1
Sale 2
Sale 3

Individ 2 Subtotal

 

[Duane Hookom]

No, what I suggested won't work to return multiple values from the same
subreport. You would need to create a totals query with the values that you
want and then include it as another subreport on your main report.