topic Re: WRS report with prompted filters in SAS Web Report Studio

WRS report with prompted filters

huikeng_sas — Mon, 16 Aug 2010 08:49:35 GMT

Hi,

Currently, whenever we view a WRS report with prompted filters, the filter selection page will appear first and only when we click on "View Report" then our WRS report wil be displayed on a new page.

How can we put the WRS report and the prompt selection side-by-side?

Or are we able to achieve this easily with some customisation?

Any comment / suggestion / insights will be much appreciated.

Thanks!

Re: WRS report with prompted filters

AngelaHall — Mon, 16 Aug 2010 13:40:35 GMT

I am not aware of a mechanism to do this using prompts in WRS.
There are a couple alternatives.
1. You could create a group-by for your report and allow the user to select the value on the left side of the report viewing screen.
2. You could create a separate section for each previously prompted value and the user could choose which section to view.

However both of the prior options only work well when replacing 1 prompt.

Another completely different approach is to create a custom SAS Stored Process with the prompts (created in HTML code via DATA _NULL_ put statements) on the left and the report on the right.

Hope this helps.
~ Angela
http://sas-bi.blogspot.com

Re: WRS report with prompted filters

huikeng_sas — Mon, 16 Aug 2010 16:22:25 GMT

Hi Angela, thanks for your suggestion. do you happen to have any stored process sample codes for me to test out?
Thanks!
Hui Keng

Re: WRS report with prompted filters

AngelaHall — Mon, 16 Aug 2010 17:34:44 GMT

Hui,
Here is a simple example from the SAS Sample site on how to generate a custom form within the STP code:
http://support.sas.com/kb/37/050.html

To place both html data _null_ code (such as the above sample) and SAS proc output together on the same page, refer to my recent blog post at:
http://sas-bi.blogspot.com/2010/07/combining-graphsprocs-with-custom-html.html

~ Angela