[zax]

Hi,

I think what I need is a crosstab, but with static rows. I am looking for something like this:

            1   2   3   4   5....
Speed       22  12  44  0   0
Colour      R   W   W   B   -
Height      2   2   2   3   2
Weight      21  23  21  26  22

Where the numbers in the top row are dynamic, and the row "headers" (Speed etc) are static. Using a crosstab and data cube, I can produce this:

1   2   3   4   5....
22  12  44  0   0
R   W   W   B   -
2   2   2   3   2
21  23  21  26  22

But I really need the labels.. Do you have any ideas how to achieve this?

Or should I use a table instead. This is table data really, but with the table on it side....

Thanks in advance,
Stephen

[mwilliams]

What do you use as your row dimension, in your cube to get the rows? What does your dataSet data look like? Let me know.

[zax]

I solved this by rearranging the structure of the report. But thanks for the offer of help.

[Hans_vd]

Hi Zax,

Can you describe in short how you changed your report?
I'd be glad to know how you did it.

Thanks