Grouping and Row limit in SSRS

reportingssrsssrs-2012

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.

Best Answer

As you said you want to do this at report level here is what i can think of:

You can try reducing the value in Height section in Interacivesize property of your report according to your needs,which is set to 11in by default and shows whatever records can fit in that much space :

Note: In case you have a small database and want to show all the values in 1 page itself setting the Height value to 0 will do the trick for you. Hope this helps.

Related Solutions

How to do Row Level Security in SSRS 2008 R2 (or 2012) with Active Directory Groups

SSRS in the Report Model is available in sql 2008 R2, but not in express edition

check http://msdn.microsoft.com/en-us/library/ms365305(SQL.105).aspx

and here is how to apply it on sql 2008 R2 http://msdn.microsoft.com/en-us/library/ms365343(SQL.105).aspx

and if you want to create a view and get TSQL and AD to talk

you can use the following functions to get username

select suser_name() as 'usrname'
or select suser_sname() as sname
or select system_user as system_

or if you want to get data from ADSI, you will need to create a linked server connection to ADSI and get users info http://blog.namwarrizvi.com/?p=254 http://www.kodyaz.com/articles/active-directory-services-queries-using-openquery.aspx

and use the where clause

finally check this article "SSRS 2008 R2: Implementing Row-level Security" http://www.sqlservercentral.com/blogs/sqldownsouth/2011/10/13/ssrs-2008-r2_3A00_-implementing-row_2D00_level-security/

Sql-server – SSRS Merge Data Across 2 Group Values

It is a bit kludgey, but here's an idea sketch... instead of merging the cells, could you fake it by placing an A in the left cell aligned to the right and a D in the right cell aligned to the left? You could then use expressions to control value, alignment, color, and borders of the two separate cells.

Let me know if you need more details. I think this would give you the visual you want. Good luck!

Best Answer

Related Solutions

How to do Row Level Security in SSRS 2008 R2 (or 2012) with Active Directory Groups

Sql-server – SSRS Merge Data Across 2 Group Values

Related Question