I have a report in which i am dynamically generating the pay codes and the respective amounts column-wise. The point is I could not accomodate all the columns in a single page so I want the split up the columns into multiple lines.
For example, I have different employees and I would want to show the pay codes under each employee number with the amount in a cross-tab. If the no. of columns exceeds 10, then I would want to show the remaining columns into the next line and so on.
PC1 PC2 PC3 PC4 PC5 PC6 PC7 PC8 PC9 PC10
100 100 100 100 100 100 100 100 100 100
PC11 PC12 P13
100 100 100
Any help is appreciated.
Thanks & Regards,