topic Re: Pass prompt values from stored process to web report in SAS Web Report Studio

Pass prompt values from stored process to web report

Cullima — Wed, 15 Aug 2012 11:20:03 GMT

Is it possible to pass stored process prompt values to a WRS report built on an info map/flat table. E.g. I have a prompt within my stored process for Region, stored process output is an html report containing a link to a WRS report which also prompts for Region. Is there a way of sending the prompt value within the link?

Re: Pass prompt values from stored process to web report

shivas — Thu, 16 Aug 2012 10:55:56 GMT

Hi,

I am not sure about this....but as a work around you can directly call the stored process with prompt directly in web report studio,

Thanks,

Shiva

Re: Pass prompt values from stored process to web report

lacrefa — Fri, 17 Aug 2012 09:55:29 GMT

Dear

You can have a look on this way but not the solution it depend where you call you Stored Process.

Simply call your report via the URL as shown in the example below:
Example Report:

Report Name: Prompted Orion Product Report.srx(Report)

Report Folder: SBIP://Foundation/Shared Data/Reports/

Parameter Prompt (as definied in Information Map Studio): Please select one or more product group

Parameter Value (as definied in Information Map Studio) : Darts

Example Call:

http://localhost:8080/SASReportLauncher/do?_report=

SBIP://Foundation/Shared%20Data/Reports/Orion%20Reports/Prompted%20Orion%20Product%20Report.srx(Report)

&Please%20select%20one%20or%20more%20product%20group=Darts

Other supported parameters:

_report = the report URL (SBIP Path)

_useDefaults = set to true or false depended on whether report launcher should allow you open the report

even if not all prompts are specified. If set to true you don't need to specify values for prompts with default value.

saspfs_sessionid= existing remote session key (can be used to single signon from other SAS applications (e.g. Portal)

Note: In order to pass an existing 'saspfs_sessionid' to the launcher application you can also register the full URL link as 'Application' in the SAS Information Delivery Portal. This would allow you to store direct report links including paramters in a Collection Portlet.

Look at to :

http://localhost:9080/SASWebReportStudio/openRVUrl.do?rsRID=SBIP%3A%2F%2FMETASERVER%2FUsers%2Folisdemo+olisdemo%2FMy+Folder%2FDemo+usage+Cube+Olap+dans+WRS.srx%28Report%29

These way ask the entry point (Web application, WEb STP application, IDP, WRS etc..), if you uses the Single Sign On, ect...

A other way could be also use dataset to share your parameter, or create a STP inside a WRS and link it with a second WRS.

Best kinds

Re: Pass prompt values from stored process to web report

Cullima — Mon, 10 Sep 2012 11:59:19 GMT

Thanks for your help. I have tried the solution but can't get it working. This is the link I am trying:

http://vibbpsws01.corp.aco.uk:8080/SASWebReportStudio/openRVUrl.do?rsRID=SBIP%3A%2F%2FMETASERVER%2FDI+Custom+Tree%2FWRS_TEST.srx%28Report%29&regionprompt=EAST

Any further suggestions?

Also, can you please explain how I add the other supported parameters listed above to my link.

I have tried using thefollowing method to pull the url but I get an error message from my mail client (Lotus Notes 7) as the link is too long. If somone could post a sample url with prompt value i'd be grateful.

http://support.sas.com/documentation/cdl/en/citug/63816/HTML/default/viewer.htm#n1kaxrhektg72kn1800i55qwjpfd.htm

Many thanks