SSRS automatically run report & save pdf output to

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

SSRS automatically run report & save pdf output to

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-01 : 09:09:43

Good day, I need help.

I normally run a report via url and add the &rs:Format=PDF to open file directly in PDF format.

But i now need to automatically run the report onclick of an html button & save pdf to c:

Is this possible, how?

Regards

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-01 : 13:03:24

I just went through my doc of all available parameters and I do not see anything that lets you output to a destination with PDF. Might possibly with web services call but I have never done that.

John
It's a small world (but I wouldn't want to paint it)

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-02 : 01:08:47

Thank You - what alternative options do i have?

cvraghu
Posting Yak Master

187 Posts

Posted - 2009-12-02 : 03:16:39

Check this ---

http://weblogs.asp.net/srkirkland/archive/2007/10/29/exporting-a-sql-server-reporting-services-2005-report-directly-to-pdf-or-excel.aspx

Also check whether you can create a subscription on the fly.

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-02 : 03:59:21

It gives me all kinds of errors, struggling.

do you perhaps have an example?

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-02 : 08:17:06

Great example!

ismailc, what errors are you getting.

In article:
"Note that the identity of the application pool that your website runs under will need to have at least "browser" access to the folder containing the report you want to display. This is usually pretty simple if both the IIS and SSRS server are within the same domain, but it might be tricky if this is not the case."
and
"One potential issue that you might run into upon deploying your project is that your application server may not have the ReportViewer DLLs that are needed. You have two options in this case. The first is to copy the three Microsoft.ReportViewer.*.dll's (ReportViewer.Common.dll, ReportViewer.ProcessingObjectModel.dll, and ReportViewer.WebForms.dll) from your development computer into the BIN folder of your application server (or into the GAC)."

John
It's a small world (but I wouldn't want to paint it)

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2009-12-03 : 07:31:07

Hi, Thank You

I found a way running the report using vbscript but it saves a damaged file.

Is there permissions needed to save a report!

Regards

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-12-17 : 14:17:45

problem could be the URL you are specifying in the vbscript. I had same problem where report seemed "damaged"

it should be https://[ismailc.org]/Reportserver

go to the above URL and you will a different view of the report server, drill down till you see your report. right mouse click on your report and you will see the url you need to use.

https://[ismailc.org]/Reportserver?%2fx%2fx%2fx+x%2fx+x+x+x&rs:Command=Render

Which is different from the url you see when running the report

https://[ismailc.org]/Reports/Pages/Folder.aspx?ItemPath=%2x%2fx%2fx+x&ViewMode=List <---- DO NOT USE THIS URL

hope it helps

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources