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