SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 45476: In SAS® Web Report Studio, linked crosstabulation tables can pass only formatted character values to character prompts in a target report

DetailsAboutRate It

In SAS Web Report Studio, linked crosstabulation tables can pass only formatted character values to character prompts in a target report. This rule means the following:

  • You cannot pass numeric values, date values, or unformatted character values to a character prompt in a target report.
  • Note: If a format is not applied to the character data item in the source report, then, for linking purposes, the formatted values are considered to be the values that result from applying the default format. Often, the value displayed with the default format is the same as the unformatted value.

  • Formatted character values must be valid values for the prompt in the target report; otherwise, no results are returned.
  • For example, say that you have applied a user-defined format to a Gender data item so that F displays as Female and M displays as Male. If the results are displayed in a crosstabulation table, then the clicked value (either Female or Male) is passed to the prompt for Gender in the target report. If the prompt in the target report can accept only the unformatted values (F or M), then no results are returned. In this example, in order for the prompt to correctly process the formatted value, you must use one of the workarounds in SAS Note 40276.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report Studio64-bit Enabled AIX4.29.2 TS2M0
64-bit Enabled Solaris4.29.2 TS2M0
HP-UX IPF4.29.2 TS2M0
Linux for x644.29.2 TS2M0
Solaris for x644.29.2 TS2M0
Windows Vista for x644.29.2 TS2M0
Windows Vista4.29.2 TS2M0
Microsoft Windows Server 2008 for x644.29.2 TS2M0
Microsoft Windows XP Professional4.29.2 TS2M0
Microsoft Windows Server 2003 for x644.29.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition4.29.2 TS2M0
Microsoft Windows Server 2003 Standard Edition4.29.2 TS2M0
Microsoft Windows Server 2003 Datacenter Edition4.29.2 TS2M0
z/OS4.29.2 TS2M0
Microsoft® Windows® for x644.29.2 TS2M0
* 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.