Limit number of columns per page in Crosstab?

[Gurpreet]

Can we limit number of columns per page in CrossTab? We have a data-source that contain more than 15 columns, and when we bind it with Cross tab then the remaining columns that  are not fit in the first page goes to the bottom of next page(image- Cross Tab Print at Bottom).Can we control this behavior and make sure remaining columns always print from the top and with correct margin?

[Neli]

Hi Gurpreet,

In your case, you may try to divide the crosstab into two crosstabs depending on the desired amount of columns that you want to have on one page. This is the only option that I can suggest because of the way the horizontal page break works. For more information, you can refer to Understanding Pagination article (Horizontal Paging).

Regards,
Neli
Progress Telerik

[Gurpreet]

Is there a way to dynamically limit the number of columns displayed per page in crosstabs or adjust the crosstab's placement on subsequent pages? Our specific case involves generating graphs and crosstabs at runtime, which might have unique requirements. If possible, could you provide any working examples or further guidance to assist us?

Our scenario involves generating a graph and a crosstab at runtime, based on the chart title within a parent crosstab. The graph appears first, followed by the crosstab. The parent crosstab is organized using row grouping based on ChartTitle, and the child crosstabs use both row and column grouping. However, when the number of columns exceeds the page size, the rendering engine creates an extra page, and the child crosstab starts from the same location, leaving the top part of the page blank where the graph was previously displayed. I have attached a screenshot that clearly illustrates what went wrong.

[Todor]

Hello Gurpreet,

The observed behavior is due to the horizontal pagination as explained in the post of Neli.

You may avoid the empty pages due to the horizontal paging - see the SkipBlankPages property of the Report item.

If you need to avoid the empty space above the Crosstab that forced the horizontal pagination, you need to make sure it starts on a new page. For example, you may place the Graph and the Crosstab in different Report Sections or Report Groups that expose the property PageBreak.

You may consider also shrinking the Crosstab columns or reducing their number. You may check the following articles that elaborate on creating/editing tables dynamically:

• How to add multiple tables dynamically based on the data source
• How to Create a Dynamic Table, Crosstab, or List Item
• Create a Report in which the User May Switch and Hide/Show Table Columns Dynamically
• Modify Table with Preset Styles and Width Dynamically