Post reply

Launching a Report from the URL link

  • March 5, 2013 at 12:41 pm

    #269283

    Hello All,

    I'm using SSRS 2008 R2. After rendering a report, I want to be able to copy the URL link in the Browser's Address Bar of the rendered report and email that link to someone giving them the ability to also view that report without having to re-run the search criteria.

    Currently, when I capture the URL link and paste it in a new browser Window, I basically have to regenerate the report by entering the search criteria and clicking on the View Report button. My expectation is for the search criteria to imbedded in the URL link.

    Does anyone have any experience with this or know if it can even work?

    Thanks,

    Ronnie

    --------------------------------------------------------------------------------

  • March 5, 2013 at 6:08 pm

    #1593707

    Good idea but unfortunately it doesn't work like that. Report parameters are not captured as url parameters.

    Take a look at some options like snapshot, Report History, Caching, default parameters.

    One or a combination of these might solve your issue.

    I think perhaps snapshots would be what you want but it's worth exploring them all.

    In the report manager website, browsing to the "manage" setting for a report will show you where to set these options. Some are not intuitive though so best to read what they all do first.

  • March 5, 2013 at 7:05 pm

    #1593721

    Thank you very much for your advice.

    I will look into those options to see how they might work for me.

    Thanks again...

    Ronnie

  • March 8, 2013 at 3:20 pm

    #1595144

    While you can't just execute a report in your own browser and copy the URL to send to someone else, you can pass report parameters within a URL using ReportServer.

    See this link here: http://msdn.microsoft.com/en-us/library/ms155391(v=sql.105).aspx

  • March 8, 2013 at 3:24 pm

    #1595149

    Great Information GoVelo!

    Thank you. That's about as close to what I needed as I've gotten.

    Thanks Again!

  • March 10, 2013 at 4:43 pm

    #1595343

    Thanks GoVelo, learnt something new 🙂

  • March 11, 2013 at 7:10 am

    #1595532

    No problem! I've never actually used it, but I was pretty sure it was possible. I tried doing what was stated in the original post and obviously got the same result where you still need to select parameter values. At that point, it was going to drive me crazy if I didn't figure out how to do it! 😀

  • July 21, 2013 at 4:57 pm

    #1634329

    You can create a data driven subscription for the user. Here you can define the report parameters and the report generates based on those and emails itself to the user, based on a schedule. You can have the parameters be dynamic, like only looking at data from the previous month. When you create the subscription, there is an option to include a link to the report that you can have in the email as well. The link runs the report from SSRS and passed the appropriate parameter values.

    Hope this helps

    ----------------------------------------------------

Viewing 8 posts - 1 through 7 (of 7 total)

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