BookmarkSubscribeRSS Feed
Cullima
Calcite | Level 5


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?

3 REPLIES 3
shivas
Pyrite | Level 9

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

lacrefa
Calcite | Level 5

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%2Folisdem...

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

Cullima
Calcite | Level 5

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%2FD...

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#n1kaxrhektg72kn1800i...

Many thanks

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2375 views
  • 3 likes
  • 3 in conversation