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.
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.
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
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.