Dynamic column placement

I have made a cross tab report which have question description column as the first column and different dealer numbers like below

Questions dealer1 dealer2 dealer3 …

Dealers comes based on zone selection. If some zones have more than 16 dealers the report goes to two pages horizontally.

My requirement is
if number of dealers > 16 then questions should again appear on the left hand side of the report in the second page like

Questions dealer1 … dealer16
Page 1

Questions Question17 …
Page 2

Note that page2 above means second page horizontally.
I will be greatful to any help or suggestion in this regard.


dgoswami :india: (BOB member since 2004-06-30)

I assume the questions are the header column of the crosstab and dealers are the rows and you want the questions repeated on every page.
Format Crosstab - On the page layout tab in the page break accross section check the repeat header on every page box.


ken.gaul :uk: (BOB member since 2002-06-18)

Thanks Ken I am able to solve the problem with this


dgoswami :india: (BOB member since 2004-06-30)