This is a migrated thread and some comments may be shown as answers.

Limit number of columns per page in Crosstab?

2 Answers 212 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Gurpreet
Top achievements
Rank 1
Gurpreet asked on 02 Jan 2020, 05:27 PM
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?

2 Answers, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 07 Jan 2020, 12:25 PM

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

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Gurpreet
Top achievements
Rank 1
Iron
answered on 30 Oct 2023, 06:19 PM
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
Telerik team
commented on 02 Nov 2023, 01:20 PM

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:

 

Tags
Report Designer (standalone)
Asked by
Gurpreet
Top achievements
Rank 1
Answers by
Neli
Telerik team
Gurpreet
Top achievements
Rank 1
Iron
Share this question
or