Reporting Services 2000

Hi

I have used Reporting Services 2000 to create a template, and works in a mail merge sort of way, creating a delivery note for each order.

The problem I have is, if an order goes over two pages.. I need a easy way to present this, so that the user knows to send two pages.... Obviously, the correct way would be to page it in some way but from what I understand, RS 2000 would page the whole documents (ie all orders) and there is no way of paging in respect to a group (ie order no)

The next option is to have cont. at the bottom of page 1 (if there are more than 1 page), does any1 know how to do this? cos of obviously on the screen it will always be 1 page?

I hope I make some sense... any help would be great....

Thanks in advance :)

Have a textbox in your page footer with text "Contd." and then handle the visibility of the textbox based on the expression: IIf(Globals!TotalPages>1 and Globals!PageNumber <> Globals!TotalPages, false, true)

Shyam

|||

Thanks for the reply... but Globals!TotalPages is total number of pages in the report ... which in this case deivery notes for several different orders.... I have a order_no group in my report so that there is a page break after each order...

For example the total number of pages maybe 9, being 8 different orders, 1 being over 2 pages (eg page 3 and 4)... and if the above code would create cont in first 8 pages, while I would only want it on page 3... am i right?

Thanks again...

|||

Reporting services does not give the control on what is happening on every page. You can only use constants, globals and parameters in the footers and headers.

If you know how many records occupy 1 page on an average, you can just give a warning in your group header to look for more pages if the number of records in that group exceeds that count. Have a highlighted textbox in your header and have the visibility of that textbox based on an expression something like this:

IIf(Count(Fields!Order_no, "Group1") > 10, false, true)

Shyam

|||

i worked a way around this by retrieving the number products in the order and controlling the visibility of the text box with text "cont." by this number....

=IIf(ReportItems("CountProduct").Value
< 26, true, false)

seems to work! But i need to change it so that it works for all pages, n not for just page 2.... what if the order has 5 product lines?

I have come across another problem.. does anyone know how to hide the header footer in all pages apart from page 1 for each order_no?

Thanks alot for all the help so far :)

|||

No, you can only control if it should be printed on first and last page of the report. Use PrintOnFirstPage and PrintOnLastPage properties of header and footer to do this.

Can you please mark this post as answered?

Shyam

|||

Maybe the following link will be of some help to you:

http://blogs.msdn.com/chrishays/default.aspx

Look for topics "'Continued' Header on Subsequent Pages" and "Reset Page Number on Group"

Shyam

|||Thanks for all your help :)|||Maybe you marked a wrong post as the answer?