Using SQL Reporting Services with WAB

460
9
01-19-2018 11:10 AM
CCWeedcontrol
Regular Contributor

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.

0 Kudos
9 Replies
RobertScheitlin__GISP
MVP Esteemed Contributor

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.

0 Kudos
CCWeedcontrol
Regular Contributor

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

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

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?

0 Kudos
CCWeedcontrol
Regular Contributor

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.

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

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

0 Kudos
CCWeedcontrol
Regular Contributor

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.

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

Well, lets see if anyone chimes in.

0 Kudos
CCWeedcontrol
Regular Contributor

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?

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

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

0 Kudos