Hi there,
I need to make some financial statements (profit & loss + balance sheet); but am kinder stuck
Crystal version: 8.5
Database and connectivity: SQL Server
Sample data:
Am using a Sequel view to select the following data
Date, AccountNo, AccountDesc, Amounts.
(Data entry is done at the mid and end of the month for every account.)
Expected output:
I need to achieve the following.
Perform grouping(shown as INCOME: in example) by account desc.
For each of the accounts within the group( e.g. beef, pork, mutton), am required to sum up the monthly amounts and then display the amount in the appropriate department column.
The only way to tell what amounts, under each group are for which dept is on the account codes (dept1 - 61000*, dept2 - 61100*, dept3 - 61200*)
How do i achieve this?
SAMPLE OUTPUT...
Dept1 Dept2 Dept3 TOTAL
INCOME:
Beef 12,000 10,000 2,000 24,000
Chicken 5,000 4,000 1,000 10,000
Mutton 4,000 10,000 2,000 16,000
Pork: 3,000 6,000 1,000 10,000
I need to make some financial statements (profit & loss + balance sheet); but am kinder stuck
Crystal version: 8.5
Database and connectivity: SQL Server
Sample data:
Am using a Sequel view to select the following data
Date, AccountNo, AccountDesc, Amounts.
(Data entry is done at the mid and end of the month for every account.)
Expected output:
I need to achieve the following.
Perform grouping(shown as INCOME: in example) by account desc.
For each of the accounts within the group( e.g. beef, pork, mutton), am required to sum up the monthly amounts and then display the amount in the appropriate department column.
The only way to tell what amounts, under each group are for which dept is on the account codes (dept1 - 61000*, dept2 - 61100*, dept3 - 61200*)
How do i achieve this?
SAMPLE OUTPUT...
Dept1 Dept2 Dept3 TOTAL
INCOME:
Beef 12,000 10,000 2,000 24,000
Chicken 5,000 4,000 1,000 10,000
Mutton 4,000 10,000 2,000 16,000
Pork: 3,000 6,000 1,000 10,000