locked
Add Serial Number and page number on report RRS feed

  • Question

  •  

    Hi All,

                I am using SQL Server 2005. I have an application which contains 100 records.

    I want to add a column ie Serail no. Which give me details of record ie 1,2,3,.......,100.

    Also I want to add Page number which will give me exact page number.

    I also want to disaply todays date on report.

     

    Detailed procedure is appriciated.

    Thanks in advance.

    Friday, October 24, 2008 6:16 AM

Answers

  •  

    Hello,

     

    1. To Display Serial Number You can use  Expression as         =RowNumber(Nothing)

    2. To Display Page Number, In the Page Header or Footer Place a Text Box and write expression as

    =Globals!PageNumber & " of " & Globals!TotalPages

    3. To display Report Genearated Date with Time write Expression as  =Now()

     

     

    Hope this helps

     

    Friday, October 24, 2008 6:22 AM

All replies

  •  

    Hello,

     

    1. To Display Serial Number You can use  Expression as         =RowNumber(Nothing)

    2. To Display Page Number, In the Page Header or Footer Place a Text Box and write expression as

    =Globals!PageNumber & " of " & Globals!TotalPages

    3. To display Report Genearated Date with Time write Expression as  =Now()

     

     

    Hope this helps

     

    Friday, October 24, 2008 6:22 AM
  • Hi ,

                Thanks for the reply. I have gone through all the expressions. It really works as a magic for me.

     

    Cheers!!!!!!!!!

     

    Friday, October 24, 2008 6:34 AM
  • It worked fine... Thanks a lot...

     

    Thursday, November 20, 2008 9:01 AM
  • Thank you
    that is realy helpful


    Amitsp
    Tuesday, July 7, 2009 1:22 PM
  • Thanks Shilpa, I was struggling for this for the last 2 hours.
    Wednesday, October 14, 2009 9:32 AM
  • Thanks a lot..it works like gem
    Wednesday, April 21, 2010 8:40 PM