SSRS Reporting: How to limit the number of rows returned in a group

sql-server reporting-services ssrs-2008 ssrs-tablix ssrs-grouping
Guillermo Greco picture Guillermo Greco · Feb 18, 2015 · Viewed 8.4k times · Source

How can I limit the number of rows returned in a group?

So far, when the report runs, it returns a lot of records for each group. However, I only want it to return the top 4 records in each group.

I tried the expression: =Ceiling(RowNumber(Nothing)/4) but that's not what I am looking for.

I am using SQL Server 2012 Data Tools (Visual Studio 2010)

Thanks.

Answer

Jeffrey Van Laethem picture Jeffrey Van Laethem · Feb 18, 2015

In the group's properties, set a filter on the field you want, choose "Top N" as the operator, and 4 as the value.

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
SSRS the definition of the report is invalid

How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Message: Error : The definition of the report '/OrderAnalysis' is invalid. Report Element: <Report …

Read More
SSRS 2008: error message saying my parameter doesn't exist but it clearly does?

I have a report that has about 10 parameters and about 10 datasets and one datasource. I typed alot but I really need help so I figured I would try and provide as much info about the problem as I could right …

Read More