I need some help figuring out how to add grouping to get only the items I want on a page of a table

1 Answer 14 Views
Top achievements
Rank 1
Richard asked on 13 Jun 2024, 08:03 PM

Let’s say we have the data below.

How could I put this into a table and it show only the items in each Pet/Grouping per page.    

For example:

Page 1

Page 2

Page 3

I tried making a group header for Pet, with a child of Grouping and then putting a page break at the bottom of the Grouping group but that didn’t work.  I always get the result at the bottom here.

What am I missing?


1 Answer, 1 is accepted

Sort by
Dess | Tech Support Engineer, Principal
Telerik team
answered on 18 Jun 2024, 01:05 PM

Hello, Richard,

I have prepared a sample report using a csvDataSource with the pets records mentioned in the initial post:

1. This source is used as a DataSource for the Table item added in the report:

In the Preview window, the whole data is displayed at the beginning:

2. In the Group Explorer, you can add a parent group to the Pet field:

3. In the Preview mode you can see the first level grouping:

4. Click the Group Properties to open the Edit Table Group dialog:

5. Set the PageBreak property to After:

6. Now, previewing the report shows the two main groups on separate pages:

7. Add a Child group for the Grouping field and adjust the setting again to have a PageBreak with value "After":

Now, the data is previewed as expected, each group is on a separate page:

The following help articles are quite useful about getting started with the grouping functionality available in the Telerik Reporting:

Grouping Data Overview

Adding Groups to Table and Crosstab Items

Adding Groups to Report

Off topic, you can enable the columns heading on every page by setting the table's ColumnHeadersPrintOnEveryPage property to true:

Thus, the groups will look much better:

I hope you find this information helpful. Please, let me know if there is anything else I can assist you with.

Dess | Tech Support Engineer, Principal
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Top achievements
Rank 1
commented on 18 Jun 2024, 02:24 PM

Thank you so much!  You explained this so well, I was able to go apply this to my much larger report and it worked amazing.  I am really beginning to love this reporting tool much better than SSRS.  Applying it to my MVC applications is so simple and it looks outstanding.   Thanks again!



Asked by
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Share this question