Hello,
I have similar problem but here is situation i.e., I have a cross tab with 3 row groups and multiple column groups. When data filled in cross tab,first row group is blank when the second & row groups having the data.What we need is that crosstab should allow duplicate values instead of blanks. I tried to having a invisible column but didn't worked for me.
RowGroup1 RowGroup2 RowGroup3 ColumnGroup1 ColumnGroup2
1 11 111 22 23
12 121 24 24
So,Here in second row,We need to display 1 in first column.
Can any one please help me to succeed from this situation?
Please let me know if you need any further details to get this done?
Thanks,
Gollapudi.