Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show word Continued at the end of each page

Status
Not open for further replies.

nsimmons

Technical User
Apr 3, 2002
19
GB
Hi all,

I have a table on a SSRS page that displays about 5 pages of information. I'd like to be able to put the word 'Continued' on each page except the last. Does anyone know how this could be done?
Some of the rows are longer than others so there is never a set number of rows on each page.

Thanks.
 
In the Hidden property of the Textbox with "Continued" in it, use an IIF() statement to compare if @PageNumber = @TotalPage or IF @TotalPage equals one then hide.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------
 
Thanks - That would work but I don't think I explained the whole problem.
Basically it's a financial statement run for a list of clients. For some clients their statement fits on one page so that's fine. But for others they can run to 2 or 3 pages.
The Statements for all clients run in the same report which is about 400 pages long so I needs it to show "page 1 of 1" for the client statements that fit on one page and "page 1 of x" for any other client + the words "Continued on next page" on each page but the last.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top