Pagination

[windhopper]

Hi All I'm new to SQL reporting services and have bought a book on it but can't seem to find out how to do pagination on my reports. Can anyone help? Thanks in advance

"Sex is not the answer, it's the question and the answer is yes"

[Paddy Boyd]

Is the pagination not a function of how your report is displayed - e.g. it will be differnt in a web page than in an excel file. I think the report manager (in 2005 anyway) handles it's own pagination.

[windhopper]

I just want the report to display the page number in the footer but can't find how to do this?

"Sex is not the answer, it's the question and the answer is yes"

[Wendelius]

Hi, - add a Textbox from toolbox - right click on textbox - select Expression... - add formula to expression =Globals!PageNumber Hope this helps, MIka

[windhopper]

Thanks, it worked perfectly! Just inquisitive to know now. Is there a way to say something like "Page 1 of 10" instead of just the page number?

"Sex is not the answer, it's the question and the answer is yes"

[Wendelius]

Yes, you can modify the expression any way you want, for example:

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

For additional info refer to: Using Expressions in a Report (Visual Studio Report Designer)[^] Mika

[windhopper]

Great, Thanks for the help. I really appreciate it. Cheers

"Sex is not the answer, it's the question and the answer is yes"

[Wendelius]

You're welcome :) Mika