SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 35642: Passing hidden values to prompts in a linked SAS® Web Report Studio report

DetailsAboutRate It

Overview

With the second maintenance release for SAS® 9.2 (TS2M2), SAS Web Report Studio enables you to pass hidden values to prompts in a linked report. The hidden values can be either of the following:

  • categories that are being used as group breaks.
  • filtered categories that are not visible in the table.
  • Note: This feature was added for OLAP-based reports in version 4.2_M1, and for relational reports in version 4.3.

The grouped or filtered data item must be manually associated with the related prompt.

Passing group break values

In the following relational report, the Country category is assigned to group breaks.

image label

This report is linked to a target report that includes a prompt for Country. Here is how the data item/prompt association is made in the Report Linking dialog box. Notice that Country is identified as a group value.

image label

If you click one of the linked values in source report (shown below), the value for the currently selected group break (Canada) is passed to the prompt for country in the target report, and the prompt window is bypassed.

image label

Here are the results displayed in the target report, which is filtered to show only Canada.

image label

Passing filtered values

For an example of passing values for a filtered hidden category from an OLAP-based report to a relational report, see "Passing values for an applied filter" in SAS Note 36631.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report StudioMicrosoft Windows Server 2003 Datacenter Edition4.2_M19.2 TS2M2
Microsoft Windows Server 2003 Enterprise Edition4.2_M19.2 TS2M2
Microsoft Windows Server 2003 Standard Edition4.2_M19.2 TS2M2
Microsoft Windows Server 20084.2_M19.2 TS2M2
Microsoft Windows XP Professional4.2_M19.2 TS2M2
Windows Vista4.2_M19.2 TS2M2
64-bit Enabled Solaris4.2_M19.2 TS2M2
HP-UX IPF4.2_M19.2 TS2M2
Linux4.2_M19.2 TS2M2
Linux for x644.2_M19.2 TS2M2
Solaris for x644.2_M19.2 TS2M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.