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?