Skip to Content
0
Former Member
Oct 02, 2012 at 06:11 PM

How to transpose fields in CR 14

37 Views

Hi,

Before I go experimenting too much...

I have a report, in simplest terms, three columns, and anywhere from 6 to 12 rows.

The header consists of:

First column, label can be 'thick', 'sqft', 'energy',... depending on a formula. The other two are literals 'price' and 'uom'.

The columns are:

First column, also determined by a formula similar to the header, a numeric price, and an alpha uom field.

I'm looking for some tricks to display this horizontally; three rows tall, and 6 to 12 columns wide.

Is it possible to use a cross tab for this? Any other thoughts?

Thanks,

Matt