This is my setup:
- I've a few reports developed using Business Intelligence Development Studio & deployed on Reporting Services in SharePoint Integrated mode.
- The RDL files are deployed to a Report Library in SharePoint
- A simple site page lists all the available reports. By default, when clicked on the report, you get the HTML report. But we wanted the Excel report directly. Clicking on the link should show the File save/open dialog.
I found out about URL Access The URL for the report is of the format: http://server.com/subsite/_vti_bin/reportserver?http://server.com/subsite/Sales/YearlySalesByCategory&rs:Command=Render
How do I automatically calculate this URL for each item in the Report Library without hardcoding anything? A calculated column doesn't display a hyperlink. A hyperlink column can't have dynamic links ...
Ideally I would prefer a setting either on the Report itself or on the Report library where I can specify the report output format. But there doesn't seem to be anything like that.