Print Multi table report with a range of parameters.

We have a work order print that is called from a web page using a URL. The
print consists of 4 tables. All of the recordsets use the same parameters
but come from different data sets. I have a request to make it print
multiple work orders at a time.
When I use a select for multiple work orders it prints it all in one set of
tables but I want a seperate set of tables for each work order. Is there a
way to group the tables together?
Any other ideas?You need to use a list control, and if your reports are in RS 2000, you need
to do some hand editing of the xml.
First create your list, then add the table which displays the actual data +
any textboxes for headings and such.
Then you mark your list, and set the Grouping property to the Work Order ID.
If you're working with RS 2005, right click on the list in the report,
choose Properties. Click on the "Edit Details Group" Button. Select "Page
Break at end". (Or start, if you want.)
If you're working with RS 2000, you need to hand edit your RDL like this:
Open the code version of the report
Find your list
In the Grouping section, add <PageBreakAtEnd>true</PageBreakAtEnd>
Your code should look something like this:
<List Name="List1">
<Style>
<FontFamily>Times New Roman</FontFamily>
<FontSize>18pt</FontSize>
<Color>Maroon</Color>
<FontWeight>900</FontWeight>
</Style>
<Top>0.875in</Top>
<Grouping Name="ListGrouping">
<GroupExpressions>
<GroupExpression>=Fields(Parameters!PageGroupingParameter1.Value).Value</GroupExpression>
<GroupExpression>=Fields(Parameters!PageGroupingParameter2.Value).Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
Save the code, and test the report. Did it work?
Kaisa M. Lindahl Lervik
"msc" <matt@.dontspam.com> wrote in message
news:6C0D2B4C-DCED-4559-A849-18B260FA7C03@.microsoft.com...
> We have a work order print that is called from a web page using a URL.
> The
> print consists of 4 tables. All of the recordsets use the same parameters
> but come from different data sets. I have a request to make it print
> multiple work orders at a time.
> When I use a select for multiple work orders it prints it all in one set
> of
> tables but I want a seperate set of tables for each work order. Is there
> a
> way to group the tables together?
> Any other ideas?
>sql

Print icon not available when using URL

It's possible that I am insane but shouldn't there be a print icon on the
rendered report? I am using a url but I don't think that matters. I can
print the report using the browser's print capability to print the browser
window but it will have the toolbar and parameter info on it.
Am I missing something, shouldn't there be a print icon to send the report
to the default printer?
Can I completely hide the toolbar?
Thanks for you 100 percent generous insight!
TimWith this version (hopefully with either version 2 or another service pack
what I say will not be necessary) to print (other than a screen print like
IE does) you need to export it to something like PDF and then print the PDF.
Bruce L-C
"Tim Powers" <tim.powers@.rimrock.com> wrote in message
news:%23NGnkURlEHA.3720@.TK2MSFTNGP12.phx.gbl...
> It's possible that I am insane but shouldn't there be a print icon on the
> rendered report? I am using a url but I don't think that matters. I can
> print the report using the browser's print capability to print the browser
> window but it will have the toolbar and parameter info on it.
> Am I missing something, shouldn't there be a print icon to send the report
> to the default printer?
> Can I completely hide the toolbar?
> Thanks for you 100 percent generous insight!
> Tim
>
>

Previewing a URL image in Reporting Services

Hi all
I need to place an image from a web site onto a RS report. Is it possible to
do this in SRS 2000?
IE. http://<servername>/<directory>/<image.jpg> and render the image on the
report?
Thanks in advance
GeorgeRephrasing the question:
I've assigned the image control value to be a database field containing a
valid URL however I'm getting a red cross when trying to display the report.
Anyone got any ideas?
Thanks
George
"_george" <none@.nojne@.none> wrote in message
news:#kyvEDRmHHA.4688@.TK2MSFTNGP03.phx.gbl...
> Hi all
> I need to place an image from a web site onto a RS report. Is it possible
to
> do this in SRS 2000?
> IE. http://<servername>/<directory>/<image.jpg> and render the image on
the
> report?
> Thanks in advance
> George
>|||you need to set the image source to external and then set value =Fields!image_small.Value
Or if you drag the image control from toolbox, you will see 4 options for
image source, you need to choose Image Source = "Web" which the 4th option.
Then click next and leave the URL empty...totally tempty... then click
finish. Then you can edit the value of the image to the database field...
which is full valid url.
"Cristo" wrote:
> Rephrasing the question:
> I've assigned the image control value to be a database field containing a
> valid URL however I'm getting a red cross when trying to display the report.
> Anyone got any ideas?
> Thanks
> George
> "_george" <none@.nojne@.none> wrote in message
> news:#kyvEDRmHHA.4688@.TK2MSFTNGP03.phx.gbl...
> > Hi all
> >
> > I need to place an image from a web site onto a RS report. Is it possible
> to
> > do this in SRS 2000?
> > IE. http://<servername>/<directory>/<image.jpg> and render the image on
> the
> > report?
> >
> > Thanks in advance
> >
> > George
> >
> >
>
>|||Hi
No go.
Any other ideas'
"SL" <SL@.discussions.microsoft.com> wrote in message
news:F6A170BE-6F80-4522-92DD-1DD3969AE945@.microsoft.com...
> you need to set the image source to external and then set value => Fields!image_small.Value
> Or if you drag the image control from toolbox, you will see 4 options for
> image source, you need to choose Image Source = "Web" which the 4th
> option.
> Then click next and leave the URL empty...totally tempty... then click
> finish. Then you can edit the value of the image to the database field...
> which is full valid url.
>
> "Cristo" wrote:
>> Rephrasing the question:
>> I've assigned the image control value to be a database field containing a
>> valid URL however I'm getting a red cross when trying to display the
>> report.
>> Anyone got any ideas?
>> Thanks
>> George
>> "_george" <none@.nojne@.none> wrote in message
>> news:#kyvEDRmHHA.4688@.TK2MSFTNGP03.phx.gbl...
>> > Hi all
>> >
>> > I need to place an image from a web site onto a RS report. Is it
>> > possible
>> to
>> > do this in SRS 2000?
>> > IE. http://<servername>/<directory>/<image.jpg> and render the image on
>> the
>> > report?
>> >
>> > Thanks in advance
>> >
>> > George
>> >
>> >
>>