View Page Number and Report Generated On. in SSRS

     
Page Number:

a.      Total Page : 10

b.      Current Page: 2

·         Header

o   Right Click à Insert à Text Box à Set following Expression 

 

Report Generated On

           

o   Right Click à Insert à TextBox à Set following Expression

o   Use following Expression for Report Generated On

SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE

ROW_NUMBER

·         Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

RANK

·         Returns the rank of each row within the partition of a result set.

DENSE_RANK

·         Returns the rank of rows within the partition of a result set, without any gaps in the ranking.

NTILE

·         Distributes the rows in an ordered partition into a specified number of groups

Following example is excellent example from BOL again. This function explains usage of all the four function together in one query.