Problem Note 36953: Cascading prompts might not display in SAS® Web Report Studio
 |  |  |  |  |
Cascading prompts might not display in a SAS Web Report Studio report if the prompts meet these conditions:
- They use the option User selects values from a dynamic list.
- They are included in a stored process that is associated with an information map.
In addition, the SAS Web Report Studio log might have an error message similar to the following:
ERROR [9462ba17d7c7b658:77d4e3aa:1224f43e77e:-6f29sasdemo] com.sas.prompts.simplesqlmodel.PromptValueOperand - par_sex com.sas.prompts.PromptValueNotFoundException: par_sex at com.sas.prompts.PromptValues.getPossiblyAnnotatedPromptValue(PromptValues.java:212) at com.sas.prompts.PromptValues.getPromptValue(PromptValues.java:277) at com.sas.prompts.simplesqlmodel.PromptValueOperand.getVariableOperands(PromptValueOperand.java:152) at com.sas.storage.simplesqlmodel.BaseOperator.expandOperands(BaseOperator.java:45) at com.sas.storage.simplesqlmodel.MultiValueFormattedOperator.formatOperands(MultiValueFormattedOperator.java:168)
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| z/OS | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
A fix for this issue for SAS Web Report Studio 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A55.html#36953A fix for this issue for SAS Web Report Viewer 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A62.html#36953| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting ==> Interactive Querying Query and Reporting |
| Date Modified: | 2009-08-26 13:13:01 |
| Date Created: | 2009-08-24 13:53:29 |