SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 40276: "No values were returned" when passing formatted values to prompts in a linked SAS® Web Report Studio report

DetailsAboutRate It

SAS Web Report Studio enables you to associate data items in a source report with prompts in a target report. In this way, values for the data item in the first report can be passed to the prompts in the linked report and the prompt window is bypassed. However, under the following conditions, the linked report returns no results.

  • The data item in the source report uses a format other than the default.
  • The prompt used in the target report was created in SAS® Information Map Studio.

There are two workarounds for this issue.

Create the prompted filter in SAS Web Report Studio

Create the prompted filter in SAS Web Report Studio, and select the Filter on formatted values option.

Modify the data item expression in the information map

In SAS Information Map Studio, edit the expression of the data item so that it specifies which format to use, and leave the Format type on the Classifications/Formats tab set to Default Format. Here is an example of an expression that applies a format to the Product variable in the PRDSAL2 table.

PUT(<<PRDSAL2.PRODUCT>>,$PROD.)

CAUTION: If you are using a third-party database, this workaround can degrade performance because the expression will not be passed down to the database for processing.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report StudioSolaris for x644.49.4 TS1M0
Linux for x644.49.4 TS1M0
HP-UX IPF4.49.4 TS1M0
64-bit Enabled Solaris4.49.4 TS1M0
64-bit Enabled AIX4.49.4 TS1M0
Microsoft® Windows® for x644.49.4 TS1M0
* 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.