Printing different group totals on same line

[mkyzar]

I have a report that has a grouping on cost_code. Each group has a sum of the revenue for that code. All I want displayed on the report is this summary amount for each code. There are 9 codes. Is there a way that I can condense them to print on one line like a detail record or must they print one line per code?

In other words, like this:

Group 1 Group 2 Group 3
Total 1 Total 2 Total 3

Instead of this:

Group 1 Total 1
Group 2 Total 2
Group 3 Total 3


All help is appreciated!

Thanks,

mkyzar

 

[synapsevampire]

Use Insert->Cross-Tab, and select the CostCode for the column, and the revenue in the Summarized Field.

Place the cross-tab in the report footer, remove the grouping from the report.

-k

 

[mkyzar]

Thank you! I knew it was something simple, but it has been a while since I used Crystal. Here is another question if you don't mind helping me a little more. In the cross-tab, is there a way to tell it not to include the first column in the total and then create a formula that subtracts the first column from the total column?

For example:
A B C D E
X 5 2 3 2+3 D(5)-A(5)


Thanks again for your help!

mkyzar

 

[mkyzar]

Never mind. I figured out what I needed to do. Thanks again for your help!

mkyzar