one template, multiple levels

[Kaszalot]

I have three levels of information (NATIONAL, STATE, CITY). For each of those, the formulas in the report have to differ by the grouping (NATIONAL will compute averages using all data, STATE will compute averages for each of the state in the database). Is it possible to have only one template if the reports do not change by the level (except for the data, of course)? Also, what are the statements used to select the different formulas depending on the level you are running?

I'm using CR10 with MS/Access.

 

[synapsevampire]

This isn't really clear to me, a good way to express requirements is to include example data and expected output.

It sounds like you just need to select Insert->Group and select state, and then you can right click any field in the detail and select Insert->Summary->Average to create averages at the group level and for the grand totals (national).

-k