SSRS Tips & Tricks

SSRS TIPS

 
http://www.mssqltips.com/category.asp?catid=20

How to set No of Rows per page in SSRS

=Ceiling(RowNumber(Nothing)/10)

 

More information available following links

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/16eee49a-53d2-49cf-a7fd-9f6f10a1eb5b

 

Expression Examples - SSRS

http://msdn.microsoft.com/en-us/library/ms157328.aspx

 

Working with Report Snapshots in SQL Server Reporting Services (SSRS)

http://www.mssqltips.com/tip.asp?tip=1922

 

SELECT
NTILE(5)
OVER (ORDER
BY Name)
FROM TestDriveUsers

 
-- Total no of records 10, if it is using NTile(5) means the output willl be this format
1 2 3 4 5 6 7 8 9 10
1 1 2 2 3 3 4 4 5 5

 
--- NTILE (4) is used to total number of rows divided by 4

 
SELECT
CEILING(ROW_NUMBER()
OVER (ORDER
BY Name)/5)
+ 1
FROM TestDriveUsers

 
1 2 3 4 5 6 ………………….
1 1 1 1 2 2 2 2 2 3 3 3 3 3 4 4 4 4 4 5 5 5 5