Post reply

How to add a link to a file in SSRS Report?

  • June 21, 2012 at 1:45 am

    #271518

    How to add a link to a file in SSRS Report?

  • June 21, 2012 at 2:23 am

    #1503814

    How to: Add a Hyperlink to a URL (Reporting Services)

    The URL you're referencing to should be a File URI.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • June 21, 2012 at 3:10 am

    This was removed by the editor as SPAM

  • June 21, 2012 at 5:34 am

    #1503874

    Thank you!

  • June 22, 2012 at 9:47 am

    #1504593

    Folks just a short note of caution on this topic:

    With file links, the real problem is not "what is the syntax" but, "once you have the syntax down, how do you deal with the rights issues for accessing the file".

    In an intranet situation, and if you are using Report Manager or a custom application with ReportViewer to expose the reports, sometimes you can plan for this by limiting access to the report to users who have rights to that file share.

    But you might still need to be careful about exports, where the link might be exposed to other users as well. For this reason, even in an intranet situation, I've pretty much given up on using them, unless exports have already been ruled out (are not exposed) or the report is 2008 R2 or higher and the link is an expression that considers Globals!RenderFormat.Name (or a similar dodge).

    Instead I'll use something like this:

    http://<myapplication>[/b%5D/FileRequest.aspx?_forward=%5Bb%5D<filename>%5B/b%5D&%5Bb%5D<addtl parameters here as needed, which don't include credentials, obviously>

    ... the proxy application serves the file back. Added work, yes, but there's rarely a scenario where a direct file link isn't going to cause more trouble.

    HTH,

    >L<

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

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