Conditional calcuation of Group summaries in Footer

[dev1212]

Hi,
I am grouping a report based on account type (A,C,X). I am calculating summaries of amounts (Sum({XYZ.Amount},{XYZ.ACTTYP})) for these accounts.
A
100
C
200
X
150

In the report footer i want to display details like

For Type A: Amount = 100
For Type C: Amount = 200
For Type X: Amount = 150

Is there any way to display this (running total?/formula?/)..?

 

[lbass]

You could just insert a crosstab that uses accounttype as the row, and sum of amount as the summary field. If you want to add a row label, you can create a formula like this:

whilereadingrecords;
"Account Type"

Add this as your first row field. In the customize style tab, check suppress subtotal for this. Then you can rotate the label 90 degrees, center it, and resize the width of the label.

-LB

 

[dev1212]

Thanks lbass for your reply. But i want to avoid cross tab as the export format requested is excel and cross tab will have the worse export with excel. Is there any way this is achievable by using running total on a formula field ? (thinking out of box)

 

[lbass]

Sure, it just can be tedious if there are many types.

Insert one running total per type. Choose sum of amount, evaluate using a formula: {table.type} = "C", reset never.

Then add text boxes for the text that identifies the type or create a formula that builds in the text and running total.

-LB

 

[dev1212]

that is exactly what i was looking for.

Thank you lbass