Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Launching a Report from the URL link Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 12:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:52 AM
Points: 140, Visits: 225
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

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


Post #1426995
Posted Tuesday, March 5, 2013 6:08 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:52 PM
Points: 460, Visits: 860
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.
Post #1427103
Posted Tuesday, March 5, 2013 7:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:52 AM
Points: 140, Visits: 225
Thank you very much for your advice.

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

Thanks again...

Ronnie
Post #1427119
Posted Friday, March 8, 2013 3:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:53 PM
Points: 16, Visits: 366
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
Post #1428790
Posted Friday, March 8, 2013 3:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:52 AM
Points: 140, Visits: 225
Great Information GoVelo!

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

Thanks Again!
Post #1428795
Posted Sunday, March 10, 2013 4:43 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:52 PM
Points: 460, Visits: 860
Thanks GoVelo, learnt something new :)
Post #1429030
Posted Monday, March 11, 2013 7:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:53 PM
Points: 16, Visits: 366
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!
Post #1429245
Posted Sunday, July 21, 2013 4:57 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
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
Post #1475842
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse