topic Open WRS Report with a subset in SAS Web Report Studio

Open WRS Report with a subset

bheinsius — Mon, 13 Sep 2010 12:16:29 GMT

Hi,

Is it possible to open a WRS Report from the SAS Portal with a predefined subset?

My case:
1. Report for New York
2. Report for San Francisco

Clicking report 1 should give my WRS report with subset NY applied.
Clicking report 2 should give my WRS report with subset SF applied.

Thanks,
Bart

Re: Open WRS Report with a subset

Madelyn_SAS — Mon, 13 Sep 2010 12:28:43 GMT

You can subset reports by using filters. Are you talking about something different? Can you provide more details?

Re: Open WRS Report with a subset

bheinsius — Mon, 13 Sep 2010 12:41:46 GMT

I want to open a WRS report with a pre-selected prompt value.

For a Stored Process I would call it with something like &STATE=NY where the Stored Process picks up the STATE macro var and applies the subset to the data it queries.

Re: Open WRS Report with a subset

ShaneGibson_OptimalBI — Wed, 15 Sep 2010 00:33:51 GMT

We created a custom .jsp that allowed us to call w WRS or WRV report from the portal and pass it a set of parameters in the url string.

That allowed us to crate links or build menus in the Portal and when the user lciked on them it opened the same WRV repotr, but context senstive data based on the menu/link clicked.

It also inherited the users login session to provide single sign-on from the portal to WRS/WRV

Re: Open WRS Report with a subset

bheinsius — Wed, 15 Sep 2010 08:01:27 GMT

Shane,

That sounds like what we are looking for.
Would you share that jsp?

- Bart

Re: Open WRS Report with a subset

ShaneGibson_OptimalBI — Sat, 25 Sep 2010 06:18:07 GMT

Hi Bart

Sorry for delay just checking with moderator on forum rules, because....

We sell the mod that allows this as a comercial package, details here:

http://saasinct.com/sas-portlet-details/wrv/wrs-report-linkage.html

Cheers
Shane