Sample Header Ad - 728x90

Grouping and Row limit in SSRS

1 vote
1 answer
1377 views
I want to have row limitation(for example, display only 10 rows in every page) to my table in the report. I could limit the rows with Ceiling method where I could find refer. However, I have to group based on two criteria before using row limit. One is I want to group by category by category name, after that group by based on Region. And have my row limit after that. How could I achieve this? And I want to do all of these in report level. Kindly share any insight on that matter. Thanks.
Asked by LittleBirdy (131 rep)
Jun 7, 2016, 01:44 AM
Last activity: Aug 29, 2017, 12:01 PM