Summarize details in footer 1

[markphillipscpa]

Using Crystal 2008

I'm creating an Income Statement that list account balances by month. Account balances are a group based upon report details. Report groups are defined for accounts, departments, and divisions.

How can the accounts balances be presented on the face of the report BOTH by Department and Divison?

 

[lbass]

It depends upon how you are creating the account balances and what fields you are working with. If your balances are based on simple summaries, you might be able to use a crosstab inserted in the report header that uses department and division as row fields.

-LB

 

[markphillipscpa]

Thank you, some more information

Current report:
GH1 Division
GH2 Department
GH3 Account
Detail account transactions
GH3 Sum of account transactions by account

Would like:

GF1 to also show sum of account transactions by account, by division

Can this be done in one report, or are two reports required, one by departments and one by divisions ?

 

[lbass]

Insert a crosstab in GF1 and add the account field as the row and add the account transaction as the summary field. This would show totals per account for each group instance of division.

-LB

 

[markphillipscpa]

Thank you so much.