Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-04-01 : 10:26:36
|
| Hi,I am new to using SSRS.I just want to know how to insert page numbers in the footer on all pages but not on the first page.i.e i dont want page number on the first page but i want it on all pages on the footer.any suggestions appreciated...Thanks,Raaj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-01 : 10:35:09
|
| You can put a textbox on your footer and Access the report global variable to get the page number=Globals!PageNumberIn your case it will be=IIF(Globals!PageNumber<>1,Globals!PageNumber,nothing) |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-04-01 : 10:42:15
|
| Hey Visakh,Thanks a lot man, that solved my problem.....Raaj... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-01 : 10:45:57
|
You are welcome  |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-04-01 : 10:54:21
|
| hey visakh,I am facing another probs...actually i am having 17 pages....but when i used ur code its giving me 62 pages....and some data is skipping by pages....like i am getting date on 1st but not on 2nd...then i am getting on 3rd and not on 4th.....in tht way...... |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-04-01 : 11:01:09
|
| hey visakh...i am sorry dude....i was just new to using SSRS...So donno what happened...but now everything is fine...thanks once again.....Raaj |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-04-01 : 11:06:35
|
| Hey...sorry again dude....actually when i am viewing the report in the preview tab, i can see only 17 pages...but when i am exporting tht report to the pdf format...i am getting 62 pages...i am aware tht i can get more pages but the probs is the data is skipping.....its on 1st and not on 2nd....its on 3rd and not on 4th...so on....can u help me in solving this??? |
|
|
|
|
|
|
insert page numbers on all but not on first page