SQL 2008 R2 report server: how do I have a report open as pdf rather than render in html?

Question

SQL 2008 R2, VS 2008 Designer or Report builder 3.0, Win Server 2008

I have a report using "newspaper" style columns. When I click the link on the <hostname>/Reports site, it renders in html and there is only one column. This is expected. I know that my users can then choose "export" and export it to pdf or tiff to see it with the columns. However, I want to have the report come up as pdf when they click the link and have the browser handle it as a pdf rather than render in html. Can this be done using BIDS/Report Server in 2008 R2? If yes, how?

Thanks

Answer 1

Try the below link's suggestion

http://ryanfarley.com/blog/archive/2006/01/27/15689.aspx

 

Answer 2

Hi,

As Sorna posted, generally, in order to access the report in PDF format directly, we can specify the render format as a parameter though access. You can also refer to: http://msdn.microsoft.com/en-us/library/ms154040.aspx. However, since you need to open the report as PDF in the Report Manager, accessing reports on the Report Server through URL might not meet the requirement.

Based on my research, this is product limitation that the default rendering extension is HTML in Report Manager. Personally, I agree that it is more reasonable if we can change the default render. So, please submit your suggestion at https://connect.microsoft.com/SQLServer/. You feedback is valuable for us to improve our product and service level.

Thanks,
Tony Chain

 

---

Tony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.