Automatic PDF/TIFF generation and saving?

Ello folks...
Question for you all - I'd like to make a call from a webpage (asp or aspx)
that will call up a report with a given set of parameters, format it as a pdf
or tiff file, and save it to a location. Any ideas?
I know I can use the /ReportServer/ instance to directly call the report,
pass it the parameters I need, and render it out as a different format, but
it's the saving part that's throwing me.
Thanks!
- TerosTeros,
How about a subscription instead, or does it have to be on request?
A subscription can do this for you, but rendering on demand will always
ask.
Sorry, I don't think it can be done.
Chris
Teros wrote:
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or
> aspx) that will call up a report with a given set of parameters,
> format it as a pdf or tiff file, and save it to a location. Any
> ideas?
> I know I can use the ReportServer instance to directly call the
> report, pass it the parameters I need, and render it out as a
> different format, but it's the saving part that's throwing me.
> Thanks!
> - Teros|||I have seen someone say you can save the output stream as a file . I looked
for a previous post but didn;t find it.
The other way is to create a data-based subscription... in the subscription
row you can choose the filename and path...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Teros" <Teros@.discussions.microsoft.com> wrote in message
news:1BCA0EE4-E9B9-4BE9-8F35-55A0EB09FD96@.microsoft.com...
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or
> aspx)
> that will call up a report with a given set of parameters, format it as a
> pdf
> or tiff file, and save it to a location. Any ideas?
> I know I can use the /ReportServer/ instance to directly call the report,
> pass it the parameters I need, and render it out as a different format,
> but
> it's the saving part that's throwing me.
> Thanks!
> - Teros|||Check out the web method - RenderStream - you can render to a stream then
save the stream to a file
"Teros" wrote:
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or aspx)
> that will call up a report with a given set of parameters, format it as a pdf
> or tiff file, and save it to a location. Any ideas?
> I know I can use the /ReportServer/ instance to directly call the report,
> pass it the parameters I need, and render it out as a different format, but
> it's the saving part that's throwing me.
> Thanks!
> - Teros|||Teros,
AFAIK there is no way to do this from URL access. We do what you're doing
by calling the web service and saving the stream off to a file.
Ted
"Teros" wrote:
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or aspx)
> that will call up a report with a given set of parameters, format it as a pdf
> or tiff file, and save it to a location. Any ideas?
> I know I can use the /ReportServer/ instance to directly call the report,
> pass it the parameters I need, and render it out as a different format, but
> it's the saving part that's throwing me.
> Thanks!
> - Teros|||Thanks for the input - the report does need to be rendered on demand, so the
subscriptions wouldn't work. I'm playing with the renderstream now to see
what I can play with. It's looking pretty hopeful thus far.
Thanks!|||For PDF or TIFF files, you use the Render() method. RenderStream is used for
things like images on an HTML page.
Ted
"Mary Bray [SQL Server MVP]" wrote:
> Check out the web method - RenderStream - you can render to a stream then
> save the stream to a file
> "Teros" wrote:
> > Ello folks...
> >
> > Question for you all - I'd like to make a call from a webpage (asp or aspx)
> > that will call up a report with a given set of parameters, format it as a pdf
> > or tiff file, and save it to a location. Any ideas?
> >
> > I know I can use the /ReportServer/ instance to directly call the report,
> > pass it the parameters I need, and render it out as a different format, but
> > it's the saving part that's throwing me.
> >
> > Thanks!
> > - Teros|||Any luck Teros? I'm trying to do the same thing (I think). We have a report
that will be called from a third party application, and when it is called we
want it to create a pdf to a specific location, and then close. I'd be very
interested in knowing how you did it.
Michael C.
"Teros" wrote:
> Thanks for the input - the report does need to be rendered on demand, so the
> subscriptions wouldn't work. I'm playing with the renderstream now to see
> what I can play with. It's looking pretty hopeful thus far.
> Thanks!
>

Automate exporting reports to PDF

I have read these two sites:
http://blogs.msdn.com/bryanke/articles/71491.aspx
http://scruffylookingcatherder.com/archive/2007/12/07/printing-reporting-services-2005-reports.aspx
But I'm new to Reporting Services and these methods aren't well documented
(that I can find). I have a report that has four parameters -- the second
parameter is queried off the value of the first, and could potentially have
up to five unique values for each unique first value. I need to generate a
report for each unique device listed in the second parameter, spit it out to
PDF for us to review and email to the clients.
Is there a command that can be used to do this? Or do I need to do a SQL
query or two myself to pull those values, and using a foreach statement
generate a report for each?
Any suggestions would be fantastic.
--Nathan Loding
Systems Associate, Special Projects
WESCO NetI doubt that RS has the capabilities you're looking for as that kind of
round-tripping would be frought with really complicated issues (mainly
maintaining state management). I did a cursory look at the client proxy
objects and nothing lept out at me that seems like it'd do what you're
looking for. I can't claim this to be an authoritative answer, but
personally, I'm betting you'll have to redo the queries client-side if you're
going to mimic the Report Manager functionality.
Jacob
"Nathan Loding" wrote:
> I have read these two sites:
> http://blogs.msdn.com/bryanke/articles/71491.aspx
> http://scruffylookingcatherder.com/archive/2007/12/07/printing-reporting-services-2005-reports.aspx
> But I'm new to Reporting Services and these methods aren't well documented
> (that I can find). I have a report that has four parameters -- the second
> parameter is queried off the value of the first, and could potentially have
> up to five unique values for each unique first value. I need to generate a
> report for each unique device listed in the second parameter, spit it out to
> PDF for us to review and email to the clients.
> Is there a command that can be used to do this? Or do I need to do a SQL
> query or two myself to pull those values, and using a foreach statement
> generate a report for each?
> Any suggestions would be fantastic.
> --Nathan Loding
> Systems Associate, Special Projects
> WESCO Net

automate exporting

Hi,

I have report on an aspx page. If I click a button, I want to automate the exporting process of the displayed report. Is this possible

thanks

Yes, use URLAccess and the rs:Format parameter.

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