Group Horizontal

[sara07]

I am creating a crystal report xi. Where there are columns named Transaction Code, Transaction Amount and Credit Card Type.

Transaction Code values: PM, RF
PM: Stands for Charge By
RF: Return
I created a formula to show this text.

I am doing group by Credit Card Type and then Transaction Code. And I have created a sub report to display summary on the report footer. On my sub report: I have same groupings.

I am having a hard time displaying it as horizontal transaction types like below: For example

(cc type) By Charge Return
Visa 500,000 10,000(transaction amount)
AMEX 60,000 5,000
MC 10,000 2,000
Totals: 570,000 17,000

Totals of all amounts: 587,000

However I can only get it as this:

AMEX
By Charge 60,000
Return 5,000

Visa
By Charge 5000
Return 40000


Totals: some number

How can I get it to look like the first example listed. Please help!

 

[Madawc]

What you're after looks like a crosstab. You find them under Insert on the menu.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You don't need a subreport to use the crosstab. Just insert the crosstab in the report footer, and add cctype as your row and your formula as the column field, with the amount as the summary field.

-LB