Write a ssrs report automatically to PDF

[achester75]

I've used Alan Judens code to view an ssrs report in my web app. What I would like to do is from a button press run this report an save to pdf in a specific location without having to preview then selecting export. Any help would be appreciated.

Thanks

[alanjuden]

@achester75, I have done something similar but streamed the file out to the user instead of placing it in a specific location somewhere.

If you call into the /Report/ExportReport/?reportPath=path%20to%20your%20report&format=pdf then it will stream down to the end user.

The only other thing you'll need to deal with is if you need to pass a report parameter you'd just tack it onto the end of your url (or pass it into a POST).

[achester75]

Hi Alan Thanks for the reply. This works but isn’t quite what I want to do. Ideally the user would have the option via a button press to select any combination of report see below: They then press send email. This runs each report, writes to a specific location, then is attached the email. The creating the PDF the way you have advised creates the PDF but saves in the client download folder. I can create an e-mail and add files, but the bit I’m missing is saving the report pdf to a location the server can see. [cid:image001.png@01D54789.19298220] Alan Chester IT Development Engineer T:+44 (0)1352 793 245 Unit 15 | Manor Farm Industrial Estate | Flint | Flintshire | CH6 5UY www.tvcl.co.uk<http://www.tvcl.co.uk> [https://www.tvcl.co.uk/wp-content/uploads/sites/2/2018/11/TVC-email-footer-V2.jpg] From: Alan Juden [mailto:notifications@github.com] Sent: 30 July 2019 19:52 To: alanjuden/MvcReportViewer Cc: Alan Chester; Mention Subject: Re: [alanjuden/MvcReportViewer] Write a ssrs report automatically to PDF (#90) @achester75<https://github.com/achester75>, I have done something similar but streamed the file out to the user instead of placing it in a specific location somewhere. If you call into the /Report/ExportReport/?reportPath=path%20to%20your%20report&format=pdf then it will stream down to the end user. The only other thing you'll need to deal with is if you need to pass a report parameter you'd just tack it onto the end of your url (or pass it into a POST). — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#90?email_source=notifications&email_token=AKRIKE42N7V3A5TYP2NX4ALQCCEV5A5CNFSM4IH35Y3KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3E6HLI#issuecomment-516547501>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AKRIKE4VFCHERF723AMYSODQCCEV5ANCNFSM4IH35Y3A>. Legal Disclaimer: Any views expressed by the sender of this message are not necessarily those of Thames Valley Controls Limited. Information contained in this e-mail may be confidential and is for the use of the intended recipient only, no mistake in transmission is intended to waive or compromise such privilege. Please advise the sender if you receive this e-mail by mistake.