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;
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;