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
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:
Adding Groups to Table and Crosstab Items
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.
Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik
Rank 1
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!