Hi TravWire,
Please check this link
http://weblogs.asp.net/srkirkland/exporting-a-sql-server-reporting-services-2005-report-directly-to-pdf-or-excel
Hi TravWire,
Create a page to do the download like below:
<html> <head> </head> <body onLoad="window.location.href='myfile.zip';Javascript:window.close()"> </body> </html>
After that, you call this external page by reporting services. The download will run automatically.
Best Regards.
I have no idea how to do that. The server is constantly being updated with new files, so there'd have to be some type of automation creating all these pages to refer to. Then SSRS will need to know how to dynamically refer to them... I don't think this applies, sounded good though. All I really have to work with here is SSRS 2008 R2 sitting on SharePoint 2010, the database containing the links to all the images and files, and the Azure storage blob where they are actually stored... I've been able to generate a report that spits out a PDF or excel directly using SSRS Urls, but again it's wrapping them all in a file, which is better than nothing but not really what the client wants. So basically what is happening is the client runs a report, actually a subreport that shows a bunch of images and/or files. If they want to save them, they have to right-click Save As on each image (or file). There could be over a 100 in some cases, usually more like 5-30. So I can give them the PDF report output with all the files in one PDF or excel, but they really want all the individual files. If I can't give them a ZIP, I'd like to at least give them a single click download for each file instead of a righclick save as...
Appreciate the help...
What if I use this as a Action URLor something like it?
="window.location.href='" + Fields!AttachmentStorageUrl.Value + "';Javascript:window.close()"
I've used this before in SQL javascript:void(window.open('URL','_blank')) and that works great
Hi TravWire,
According to your description, you want to click an action to download all files(like images) used in a report instead of a report, right?
In your scenario, you can create a custom solution, add some code to retrieve those images used in the report via SSRS web service then add download action.
If you have any question, please feel free to ask.
Best regards,
Qiuyun Yu