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?

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?

Reporting Service: Render order of operations.

Just curious, but I am looking for some sort of definitive outline on
the steps reporting services goes through to render a report.
Example:
Header/Footer first.
Second starting from the top of the body of the report render the
first object.
If that object's a grid process the grid's header/footer first, then
go to each successive group until the details.
If a new page is pulled up, this happens here.
And so on..
It would help immensely creating reports, and also I have something I
can show to management who have a beef with a report and cannot grasp
why reporting service processes certain things in "illogical order".
Regards,
- jOn Nov 5, 3:38 pm, modi321 <modi...@.gmail.com> wrote:
> Just curious, but I am looking for some sort of definitive outline on
> the steps reporting services goes through to render a report.
> Example:
> Header/Footer first.
> Second starting from the top of the body of the report render the
> first object.
> If that object's a grid process the grid's header/footer first, then
> go to each successive group until the details.
> If a new page is pulled up, this happens here.
> And so on..
> It would help immensely creating reports, and also I have something I
> can show to management who have a beef with a report and cannot grasp
> why reporting service processes certain things in "illogical order".
> Regards,
> - j
Was this unclear or is there no visual work flow of how MS reporting
services renders a report?|||>From my experience, processing renders as
1. Table Header
2. Table Footer
(3. Group 1 Header)
(4. Group 1 Footer)
(5. Group 2 Header)
(6. Group 2 Footer)
...
x. Details
Order of execution appears to be top left-to-right, to bottom. Custom
Functions populated conditionally in the Details rows that store
values into (Static) global variables will render as 0 in the headers
and footers, because the data items are populated last.
Microsoft is extremely non-committal when it comes to order of
rendering.
-- Scott