topic Re: Using SQL Reporting Services with WAB in ArcGIS Web AppBuilder Questions

Using SQL Reporting Services with WAB

CCWeedcontrol — Fri, 19 Jan 2018 19:10:36 GMT

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.

Re: Using SQL Reporting Services with WAB

RobertScheitlin__GISP — Fri, 19 Jan 2018 19:23:49 GMT

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.

Re: Using SQL Reporting Services with WAB

CCWeedcontrol — Mon, 22 Jan 2018 16:19:41 GMT

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

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

Pass a Report Parameter Within a URL

Re: Using SQL Reporting Services with WAB

RobertScheitlin__GISP — Mon, 22 Jan 2018 16:48:43 GMT

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?

Re: Using SQL Reporting Services with WAB

CCWeedcontrol — Mon, 22 Jan 2018 17:57:38 GMT

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.

Re: Using SQL Reporting Services with WAB

RobertScheitlin__GISP — Mon, 22 Jan 2018 18:09:05 GMT

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

Re: Using SQL Reporting Services with WAB

CCWeedcontrol — Mon, 22 Jan 2018 19:39:51 GMT

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.

Re: Using SQL Reporting Services with WAB

RobertScheitlin__GISP — Mon, 22 Jan 2018 19:57:05 GMT

Well, lets see if anyone chimes in.

Re: Using SQL Reporting Services with WAB

CCWeedcontrol — Wed, 24 Jan 2018 15:52:41 GMT

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?

Re: Using SQL Reporting Services with WAB

RobertScheitlin__GISP — Wed, 24 Jan 2018 16:08:50 GMT

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