Using SQL Reporting Services with WAB

[CCWeedcontrol]

Has anyone added a link to an SSRS report in the eSearch or Search widgets in a WAB application? I currently have a web app and an SSRS report that i would like to link together by add a link to the eSearch or Search widgets result table after a search is preformed that will be link to ta SQL SSRS. The user would click on this link in the search results table and the SSRS report would open up with the corresponding report for that specific searched feature. Similar to the 'Using URL parameters in popups' Link .

Thanks.

[RobertScheitlin__GISP]

The link is the way to do this. Having an attribute in the data that will have the url to the report is the option you have currently.

[CCWeedcontrol]

Thank for the reply Robert. I have tried to follow the blog's instructions to add the parameter to hyperlink but i have not been successful. My SSRS report link is as follows, http://ccsrs/Reports/Page /Report.aspx?ItemPath=%2fDSD%2fPT%2fPTMasterReport. If i add the search field parameters like this,

http://ccsrs/Reports/Pages/Report.aspx?ItemPath=%2fDSD%2fPTool%2fPTMasterReport&rs:Command=Render&DXF_TEXT={DXF_TEXT}0000. it just opens the SSRS report main page it doesn't pass the DXF_TEXT parameter to the report.

If i try this below i getError - Report Manager

A required argument is missing from the URL that opens this page: ItemPath.

http://ccsrs/Reports/Pages/Report.aspx?PTMasterReport&rs:Command=Render&DXF_TEXT={DXF_TEXT}0000

Pass a Report Parameter Within a URL

[RobertScheitlin__GISP]

So if you manually replace the {DXF_TEXT} portion of the url with a valid string and paste that in our browsers address bar you can get the report?

[CCWeedcontrol]

I enter http://ccsrs/Reports/Pages/Report.aspx?ItemPath=%2fDSD%2fPTool%2fPTMasterReport&rs:Command=Render&R34398 but the report does not get generated, it just opens up the reports page.

[RobertScheitlin__GISP]

well you need to get that figured out first. Did you forget the &DXF_TEXT= portion?

[CCWeedcontrol]

I have tried various different variations but no luck including adding &DXF_TEXT=. I was hopping someone had linked ssrs report that could shine some light on how to do this.

[RobertScheitlin__GISP]

Well, lets see if anyone chimes in.

[CCWeedcontrol]

I had to change the link to go through the reportserver, like below.

http://ccsrs/ReportServer/Pages/Report.aspx?

Robert, Can this be done with your eSearch widget. Adding a hyper link like i described in the search results?

[RobertScheitlin__GISP]

If you have a working url then yes you can add that as a link in the eSearch widget.