sql server reporting services: Automatic PDF/TIFF generation and saving? -- sql server reporting services

You're in the

sql server reporting services

group:

Automatic PDF/TIFF generation and saving?

Automatic PDF/TIFF generation and saving?

Teros
6/15/2005 12:28:06 PM

sql server reporting services:

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!

Re: Automatic PDF/TIFF generation and saving?

Chris McGuigan
6/16/2005 12:55:43 AM

Teros,
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

[quoted text, click to view]

Re: Automatic PDF/TIFF generation and saving?

Wayne Snyder
6/16/2005 4:51:54 AM

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

[quoted text, click to view]

RE: Automatic PDF/TIFF generation and saving?

Mary Bray [SQL Server MVP]
6/16/2005 8:28:04 AM

Check out the web method - RenderStream - you can render to a stream then
save the stream to a file

[quoted text, click to view]

RE: Automatic PDF/TIFF generation and saving?

Ted K
6/16/2005 12:34:21 PM

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

[quoted text, click to view]

RE: Automatic PDF/TIFF generation and saving?

Teros
6/16/2005 3:12:04 PM

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!

RE: Automatic PDF/TIFF generation and saving?

Ted K
6/16/2005 3:17:09 PM

For PDF or TIFF files, you use the Render() method. RenderStream is used for
things like images on an HTML page.

Ted

[quoted text, click to view]

RE: Automatic PDF/TIFF generation and saving?

Michael C
8/10/2007 2:48:01 PM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn