Launching a Report from the URL link

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Launching a Report from the URL link

Launching a Report from the URL link

Rate Topic

Display Mode

Topic Options

Author

Message

Ronnie Jones

Posted Tuesday, March 05, 2013 12:41 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:09 PM
Points: 136, Visits: 187

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

davoscollective

Posted Tuesday, March 05, 2013 6:08 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:27 PM
Points: 408, Visits: 681

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

Ronnie Jones

Posted Tuesday, March 05, 2013 7:05 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:09 PM
Points: 136, Visits: 187

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

GoVelo

Posted Friday, March 08, 2013 3:20 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:12 AM
Points: 15, Visits: 332

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

Ronnie Jones

Posted Friday, March 08, 2013 3:24 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:09 PM
Points: 136, Visits: 187

Great Information GoVelo!

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

Thanks Again!

Post #1428795

davoscollective

Posted Sunday, March 10, 2013 4:43 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:27 PM
Points: 408, Visits: 681

Thanks GoVelo, learnt something new :)

Post #1429030

GoVelo

Posted Monday, March 11, 2013 7:09 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:12 AM
Points: 15, Visits: 332

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! BigGrin

Post #1429245

« Prev Topic | Next Topic »

Permissions