Crosstab report headers for multiple columns for rows.

Title confuses you? :-) Was not sure what else to write..

I have a crosstab report which is of the format:

| #1|#2| #3 | C1 | C2 | C3

|R1 | R2| R3 | ** ** **

Rx | Ry | Rz | ** ** **

I want to give headers to R1, R2 and R3.. Rz.., that is put (#1, #2, #3) Is that possible? How?

Thanks and Regards,

mitul

Find more posts tagged with

Comments

mwilliams

Mitul,

If I'm understanding correctly, you want to give labels to your row dimensions of your crosstab. To do this, you would put a grid in your header block above the row dimensions and insert the labels there. Let me know if you're talking about something else.

mitul

Thanks for the reply. That is correct. I already did that but the number of columns and the column data is dynamic and for large ranges the formatting goes haywire. So maybe I should ask, how can I have fixed width?

mwilliams

Mitul,

You should be able to set widths for each column of your grid and each row dimension cell using the property editor.

mitul

Thanks. I was doing that too but what was happening was that when the number of columns was large the formatting was not honored. I added blank images on the top row and that fixed the width better.

Regards,

Mitul