4

I have a crosstab with many columns but only a few rows. When I generate the report the crosstab reuses the empty space below the rows from one page and renders the next columns for the same rows. This way several pages are compacted vertically on one page: enter image description here

I want the columns from day 20 to day 27 (the second part of the crosstab) to be displayed on a new page not on the same page and leave that space empty.

Tiberiu
  • 508
  • 7
  • 17

1 Answers1

9

The solution is to set the Column Break Offset property of the crosstab to a very high value such that it exceeds the page height. This way the report will continue on the next page.

Tiberiu
  • 508
  • 7
  • 17
  • this happens with me also,but I want single table on single page,it(table) breaks into many pages by columns,I tried with Column Break Offset=0 & =5 also,but no effect – Sagar Nikam Feb 04 '13 at 08:20
  • @tiberiug Solved .. but can you describe brevity what is the meaning of this property `Column Break Offset` – Ahmed Nabil May 10 '15 at 11:33
  • I've been looking for this answer for hours. My only issue is that I'd like to print the remaining columns after the initials rather than printing all of the left-most columns, then printing the right-most columns that didn't fit. Is this possible? – LikeableBias Dec 29 '15 at 23:18