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 (BOB member since 2004-06-30)