Grouping Question

[jilllawson]

I'm using Crystal version 9.0, and a small sample of my report is below. It's grouping on Charge type. But I want all of the Network Engineering charges to be in one section, not broken out like you see below. So I'd like all 13 hours for the Network Engineering to appear together, and show a total of 13, and 1885.00. Is there a way to roll them in together so they aren't separated?

Network Engineering- Standard
HOURS DOLLARS
01/01/05 Corporation C 4.00 580.00
01/10/05 Corporation A 2.00 290.00
01/31/05 Corporation F 0.50 72.50
Total 6.50 942.50

Network Engineering- Premium
01/01/05 Corporation C 4.00 580.00
01/10/05 Corporation A 2.00 290.00
01/31/05 Corporation F 0.50 72.50
Total 6.50 942.50
Network Support
01/01/05 Corporation A 4.00 540.00
01/10/05 Corporation A 2.00 270.00
01/31/05 Corporation A 0.50 67.50
Total 6.50 877.50

 

[synapsevampire]

Change your group to a formula containing something like:

if left({table.groupfield},19 ) = "Network Engineering" then
"Network Engineering"
else
{table.groupfield}

-k