How to show PDF format of a report in SSRS webpage rather than HTML ?

  • We are using SSRS2005 and users have access to the SSRS webpage and can see reports in format of HTML. Then they can export it to any other format if they want.

    Now my question is how can I show them some reports as PDF format only (i.e rather than seeing HTML they be restricted to see PDF only)??

    Cheers,

    Amir

  • I don't think you can conditionally display some items as PDF in Report Manager. You could possibly create a URL rewrite that always add the render parameter but that would either be a universal thing or would require a lot of values stored in the rewrite folder, and it strikes me as risky business.

    My suggestion would be to have a front site with a report viewer control so that you can retrieve the list of reports and append the render format to the relevant links before serving up the links.

  • This wouldn't actually restrict them from using other formats from Report Manager but if you created a report subscription with an output format of PDF and emailed them the PDF attachment that might more or less meet your need.

  • Daniel Bowlin (5/10/2012)


    This wouldn't actually restrict them from using other formats from Report Manager but if you created a report subscription with an output format of PDF and emailed them the PDF attachment that might more or less meet your need.

    Good idea, could maybe take it further and generate pdfs to file system, and automatically upload them into the folder for viewing and have the reports themselves not available to users.

    This might help kick start any dev you need to do to automatically upload the pdfs

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/794982e4-e9a2-4328-92cd-bb2248ddbb8c

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply