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 Services & Authentication

Hi

I'm just about to embark on a project which will use Reporting Services and ASP.net.

I need to produce about 800 individual reports which will then bemade accessible via the internet. Each report will only be accessibleto a specific user so I want to allow users to be able to logon usingan asp.net form which will then redirect them to their specific report.

I believe this can be done but how and can anyone direct me to a really good tutorial?

Many thanks

Hmm, I don't think much of this forum - nobody answers your questions. Are there any so called experts out there!?? :-(

Thankfully I have managed to find it out myself but only after some time.

This should help someone with a similar problem:

http://msdn2.microsoft.com/en-us/library/ms365305.aspx

plus, if you have put the RS samples on your pc look at the forms authentication sample here:

C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample\cs\FormsAuthentication

Hope this helps

reporting services

Hi

I am very new to Sql Server 2000 Reporting Services.I just installed the Sql Server 2000 Reporting Services in my macine.When i click on Microsoft Visual Studio .NET 2003 i can see the Report Project wizard template under business inteligent project.

I selected the Report Project wizard and created one report called report1.rdl.

But i dont know how to run this report on browser.When i click on preview i can see the result.
But how run on browser and how to integrate this report with my .net application?

In report layout i can create the parameters but i dont know how to use those parameters in report.

Pl provide me help or samples on this.

thanksThere isn't much help in these forums on SQL Server 2000 Reporting Services.
Gohere instead.

HTH
KJ

Reporting services

Hi
I would like to know how to create a file programatically(VB) in the
reporting services folder, so that it can be accessed from the report
manager.Do you mean create an RDL file? You can find a walk through
on this in books online. An RDL file is just XML so you can
use the XMLTextWriterClass. Check the books online topic:
Generating Report Definition Language Programmatically
and the tutorial:
Tutorial: Generating RDL Using the .NET Framework
-Sue
On 20 Sep 2006 10:44:07 -0700, vishnu.nallamothu@.gmail.com
wrote:

>Hi
> I would like to know how to create a file programatically(VB) in the
>reporting services folder, so that it can be accessed from the report
>manager.

Reporting services

Hi
I would like to know how to create a file programatically(VB) in the
reporting services folder, so that it can be accessed from the report
manager.
Do you mean create an RDL file? You can find a walk through
on this in books online. An RDL file is just XML so you can
use the XMLTextWriterClass. Check the books online topic:
Generating Report Definition Language Programmatically
and the tutorial:
Tutorial: Generating RDL Using the .NET Framework
-Sue
On 20 Sep 2006 10:44:07 -0700, vishnu.nallamothu@.gmail.com
wrote:

>Hi
> I would like to know how to create a file programatically(VB) in the
>reporting services folder, so that it can be accessed from the report
>manager.

Reporting Service Report Background Property

Hi

I have created a report and I'm trying to adjust the background color so that the color of the report fits in better with the look and feel of the website. Thus far no luck! Any offers of help?

Check it out here:

http://www.autowired.co.uk/store/rept_serv_prob.gif

Many thanks

you probably have found this by now but just in case

in Reporting Services Property - under Background image - there is an X and and Y - try changing this to match your background colour.

cheers

jewel