Traditional web-based reporting with SAS BI tools

WRS report with prompted filters

Reply
SAS Employee
Posts: 18

WRS report with prompted filters

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!
SAS Employee
Posts: 238

Re: WRS report with prompted filters

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
SAS Employee
Posts: 18

Re: WRS report with prompted filters

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

Re: WRS report with prompted filters

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
Ask a Question
Discussion stats
  • 3 replies
  • 233 views
  • 0 likes
  • 2 in conversation