The following forum(s) have migrated to Microsoft Q&A: All English SQL Server forums!
Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Add Serial Number and page number on report

Question
0

Sign in to vote

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

1

Sign in to vote

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

1

Sign in to vote

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
0

Sign in to vote

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
0

Sign in to vote

It worked fine... Thanks a lot...

Thursday, November 20, 2008 9:01 AM
0

Sign in to vote

Thank you
that is realy helpful

Amitsp

Tuesday, July 7, 2009 1:22 PM
0

Sign in to vote

Thanks Shilpa, I was struggling for this for the last 2 hours.

Wednesday, October 14, 2009 9:32 AM
0

Sign in to vote

Thanks a lot..it works like gem

Wednesday, April 21, 2010 8:40 PM