question regarding headers and footers in reports

[thesalesdeputy]

I have a report that is displaying data that has 3 groupings.
At each grouping level, I have a sum done in a footer for that set of data. However, for one set of teh grouped data I do not want to have it show the sum. Does that make sense? Hopefully so.

That gets me to the even greater question - is there a way to tell the report that while I have a group with a header, I want it to totally skip a particular item in the group? I can't just filter that item out entirely because I need to use it elsewhere in the report.

Example:

I have a report that has loss data, premium data, and expense data. Some of this data is for widgets and some is for wackets. Furthermore, within the widgets classification, some are regular and some are nonregular. I want to have a report that shows me each widget and groups them by regular and nonregular and shows a subtotal for each. I then want a subtotal of just widgets. Then I want all the wacket data and the subtotal of that, then I want a total of widget & wacket data. If I set up footers to do all of my totalling, I end up with two lines for the wackets - 1 for "regular or nonregular" (all wackets are regular, so it sums them all) and then 1 for the wacket type itself. I've tried using Iif statements, but I get circular references.

If that wasn't too convoluted - any thoughts?

 

[dhookom]

You can add code to the On Format event of any section that cancels the printing of the section.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]