SAS Portlets, Widgets, Themes and Tutorials for sale

The current release of SAS Web report Studio (3.1/SAS 9.1) doesn’t allow you to define cascading prompts, by this I mean allowing a user to select a country and then based on the country selected allow them to select a state within that country.

However in a paper presented at SAS Forum 2008 titled SAS Web Report Studio Tips and Techniques (Paper 064-2008 )   there is an innovative way outlined on how you can provide this capability by using linked reports.

The approach they have worked out is to create a report for each level of prompt and link the reports, enabling the user to select the appropriate value on each report (i.e first report they click on country from a list, then second report shows states etc) and then be linked to the next report where they can select the next parameter value, and so on and so on.

Great thinking outside the box!

If you are aiming to deliver self service report creation to end users, then no doubt you are deploying SAS Web Report Studio to enable them to create and manage reports.

If you have SAS Portal installed it is possible to provide single-signon between WRS and Portal.

In the Portal you create a new Application link and use:

http://webserver:port/SASWebReportStudio/logonFromPortal.do

Once the user has added this to their collection portlet, they can click on it and it will bypass the Web Report Studio login screen, automatically using their authenticated login details.