Traditional web-based reporting with SAS BI tools

Issue facing on prompts in Web Reports studio

Reply
Contributor
Posts: 36

Issue facing on prompts in Web Reports studio

Hi All,
Please help me in this regard,
I have created a report in WRS.So in that prompt screen can we create a master prompt which would give the user the ability to pick which fileds they want to filter on??????? and once they pick the fileds to filter on, the remaining prompts only give them values for those fileds.

Please advice..

Thanks,
Kavi
Contributor RSB
Contributor
Posts: 72

Re: Issue facing on prompts in Web Reports studio

Which version of SAS are you using? From What I understood from your post you may need cascading prompts for this.
Super Contributor
Super Contributor
Posts: 3,174

Re: Issue facing on prompts in Web Reports studio

To the OP: suggest searching the forums (Stored Process) or search the SAS support website for related technical DOC and other reference material on this topic.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

web report studio cascading prompt site:sas.com
Contributor
Posts: 36

Re: Issue facing on prompts in Web Reports studio

Hi,

Thanks for the post.but you misunderstood my problem.This is not about cascading.I already assign cascading prompt to my all of filters.Here am explaining you once again,

I have Name, age, gender, height,weight variables, so i would like to put a prompts for these columns.So the end user may see all 5 prompts in the prompt screen page and pick the values and view the report.but here my question is in the propmt screen page does the user have the ability to choose which prompt he would like to have in that propmt screen page? i.e there is a big prompt which would contain all of my 5 columns, in that user should have ability to choose the columns i.e if he selects name,age out of 5 prompts, in that prompt page screen those 2 selected columns should displayed inorder to select the data values to view the report.

Name

All Name
Age user selects Age
Gender -------------------------------->
height
weight


Here those 2 selected prompts should be displayed liek this,

Name

All
aaaa again user selects data values aaaaa
bbbb ------------------------------------>
cccc


Age

All
12
13 --------------------------------------------> 13
14


So after this selection he is going to click view report
Contributor
Posts: 36

Re: Issue facing on prompts in Web Reports studio

Hi,

Thanks for the post.but you misunderstood my problem.This is not about cascading.I already assign cascading prompt to my all of filters.Here am explaining you once again,

I have Name, age, gender, height,weight variables, so i would like to put a prompts for these columns.So the end user may see all 5 prompts in the prompt screen page and pick the values and view the report.but here my question is in the propmt screen page does the user have the ability to choose which prompt he would like to have in that propmt screen page? i.e there is a big prompt which would contain all of my 5 columns, in that user should have ability to choose the columns i.e if he selects name,age out of 5 prompts, in that prompt page screen those 2 selected columns should displayed inorder to select the data values to view the report.

Name

All Name
Age user selects Age
Gender -------------------------------->
height
weight


Here those 2 selected prompts should be displayed liek this,

Name

All
aaaa again user selects data values aaaaa
bbbb ------------------------------------>
cccc


Age

All
12
13 --------------------------------------------> 13
14


So after this selection he is going to click view report
Ask a Question
Discussion stats
  • 4 replies
  • 249 views
  • 0 likes
  • 3 in conversation