Jun 13
Create a Download SSRS Report Link in SharePoint Document Library

This post is for Information Leadership iWorkplace clients who have Smart Columns and SharePoint Reporting Services.

A SharePoint Report Library lets users execute a report file (.RDL) and once it is rendered they can select to download the report as a PDF, Word or Excel file.

If you want users to be able to download the report directly from the library you can create a Calculated Hyperlink field (a field type that comes with Smart columns) in the report library

This assumes you have SSRS in SharePoint Integrated mode. If SSRS is in native mode then you can add the "Link to Document" content type to a document library and create links with the URL format of: http://myrshost/ReportServer?/myreport&rs:Format=PDF.

This will create a column you can use in a view to allow users to download the report without having to open it first.

The Format parameter can be replaced in the calculation with WORD, EXCEL, IMAGE, MHTML, CSV or XML depending on the format required.

Documentation for SSRS URL access can be found here: http://msdn.microsoft.com/en-us/library/ms154040.aspx

Comments

Hi, Ian. First of all, I'm ...

Hi, Ian.
First of all, I'm sorry for getting in touch through this channel, but I couldn't find another way of contacting you.
I'm trying to submit some new sites for approval, but I'm not sure the form is working properly.
When I click on the button "send" to submit the information required, it opens a windows authentication screen.
I tried to cancel this authentication screen, but then I'm being directed to a "non authorized" page.
Back to the form, if I press "cancel" instead of pressing "send", I'm being directed to the "thank you" page, but I'm not sure my informations were submitted.
Can you please take a look and get back to me?
Thank you.
Sylvia (sylvia.dantas@nuova.com.br)
 on 6/24/2013 1:20 PM