Rows to columns

[thehugedeal]

HI everyone

I have a question that I have no idea if it is possible to do or not. I need to change the data from rows to columns. The data is not in the details row. The data is located in the header row.

Code #of Accts Amt
Dispute 2 0.00
PTP 1 10.00
PAID 2 100.00

This is how I would like it

Dispute PTP Paid
# of Accts Amt # of Accts Amt # of Accts Amt
2 0.00 1 10.00 2 100.00
Again the data is not in the detail, it's in the group header.

Thank You

Bru

 

[lbass]

Try inserting a crosstab, and use {table.code} as your column and then insert {table.amt} and {table.acct} as your summaries. This will give you a display like:

Dispute PTP Paid
# of Accts 2 1 2
Amount 0.00 10.00 100.00

...if you create a formula {@label} and add it as your row field:

whilereadingrecords;
"# of Accts" + chr(13) +
"Amount"

You would then go to format crosstab->customize style->suppress column grand totals.

I'm not sure about CR 9.0, but in lower versions there isn't a way to get the horizontal display of the summary fields without doing a manual crosstab, but perhaps this will work for your purposes.

-LB