I have a Crosstab Report that has about 55 rows and 7 columns .The column values are like 121..127, 61...67 and so on; meaning it is a sequence of 7 numbers and in random order. Is there a way to change the column names to Site 1, Site2..Site7 using some formula? I added an additional report header section and created labels with text as Site 1..site 7 and suppressed the column values to see if that would solve my problem. However, the problem now is the labels Do not repeat on every vertical page. How do I get to solve this?
Any suggestion in this regard would be of great help. Thanks in advance.crosstab-column-header.jpg