Crosstab report group header question

[Chitra_Maithani]

Hi,

I have a Crosstab report and would like to show the group item horizontally (instead of vertically). Please see the attachment - the picture explains better what I am trying to achieve. I am able to create group item as a header in a List report. For the Crosstab report, I have tried to add a Crosstab Space above the Product Line row and move the Product Line data item into it - this will return 'The data item reference in the crosstab space is not valid'.

Does anyone have any suggestions what I can do? thank you.

[Raghuvir]

Hi,

Please refer the attached image, it might give u some idea how to implement your requirement. i have done it using a cross tab space.

let me know in case of any help.

[Chitra_Maithani]

thanks a lot for the solution Raghuvir.
I have tried it .But the problm is when you export the output in excel there is blank space at product line grouping.

Thanks
Chitra Maithani

[Raghuvir]

Hi,

just check the attached file for excel output and let me know if that's the desired output.

i have just changed the data to zero.