SQLServerCentral.com / Reporting Services / Reporting Services / Launching a Report from the URL link / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 17:20:58 GMT20RE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxYou 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 helpsSun, 21 Jul 2013 16:57:59 GMTMMartin1RE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxNo 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! :-DMon, 11 Mar 2013 07:09:59 GMTGoVeloRE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxThanks GoVelo, learnt something new :)Sun, 10 Mar 2013 16:43:08 GMTdavoscollectiveRE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxGreat Information GoVelo!Thank you. That's about as close to what I needed as I've gotten.Thanks Again!Fri, 08 Mar 2013 15:24:51 GMTRonnie JonesRE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxWhile 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: [url]http://msdn.microsoft.com/en-us/library/ms155391(v=sql.105).aspx[/url]Fri, 08 Mar 2013 15:20:22 GMTGoVeloRE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxThank you very much for your advice.I will look into those options to see how they might work for me.Thanks again...RonnieTue, 05 Mar 2013 19:05:46 GMTRonnie JonesRE: Launching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxGood 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.Tue, 05 Mar 2013 18:08:21 GMTdavoscollectiveLaunching a Report from the URL linkhttp://www.sqlservercentral.com/Forums/Topic1426995-150-1.aspxHello 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--------------------------------------------------------------------------------Tue, 05 Mar 2013 12:41:54 GMTRonnie Jones