show only certain types in a report

[hwkranger]

I have a report, is drawn from a table. There is a filter such that certain records won't be counted.

It's broken down by (grouped by) Operator and ticket type. Each operator does about 7 types of tickets. With the filter, I eliminate 2 types (which I don't want in my totals.) Now there are two other ticket types, that I want in the totals, but I do not want displayed under the operator.

example:

Operator: John Doe count
ticketypes: Ticket Type A 3
Ticket Type B 1
Ticket Type C 16
Ticket Type D 1
Ticket Type E 1
Totals: 22


I would like to not show Ticket type D or E, yet I would like their counts to stay in the totals. (Otherwise I would use a filter, but using a filter removes it from the totals.) Meaning I want my ex. total to stay at 22, but I don't want Ticket type D or Ticket type E or it's counts to show.

The reason for this, is with this report management wants to see 2 operators per page. They only want to see the 3 most important ticket types, and if a operator happens to work more than the 3 types, only 1 operator fits on a page of a report.

Anyone know of an easy way to do this?



Randall Vollen
National City Bank Corp.

 

[hwkranger]

no need for this post. I got it.

Randall Vollen
National City Bank Corp.