Grouping Grouped Totals?

[basquiat]

I'm using Crystal Reports 8

I am trying to create an Income Statement based on a Transaction Table;

The table has an entry for each and every transaction captured;
So there would be more than one entry per account type/code;
For example...

AccCode: AccDescr: Amount:
1000 Sales 1,000
1000 Sales 2,500
1000 Sales 2,000
2000 Stationary 50
3000 Travel 500
3000 Travel 750

On my report I want...
INCOME:
Sales 5,500

EXPENSE:
Stationary 50
Travel 1,250

I've grouped according to 'AccCode'
If I drop a running total in the report footer, I can't use the 'group expert-specific order' to create named groups to group all the income accounts and all the expense accounts together;

And if I drop the total in the details section, I can group it by 'Named Group' but it gives me the running total per entry;

INCOME:
Sales 1,000
Sales 3,500
Sales 5,500

Any ideas would be MUCH appreciated;

 

[lbass]

Create a formula like the following:

if {table.acccode} = '1000' then "Income" else "Expense"

Then insert a group on this formula and make this your highest order group by clicking on the area to the left of the group header and dragging it to the group#1 position.

-LB

 

[basquiat]

Thanks!
It's doing the trick;

But since the formula is now group1, it sorts it according to this group/formula;
I've got 4 categories "Income,Expense,Interest & Tax";
How can I get the groups in that order since it's not ascending nor descending??

Thanks for your help!

 

[lbass]

Go to report->change group expert->group1->options and change the order to "specified order" and then order the groups the way you wish.

-LB