Problem Note 40276: "No values were returned" when passing formatted values to prompts in a linked SAS® Web Report Studio report
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
SAS System | SAS Web Report Studio | Solaris for x64 | 4.4 | | 9.4 TS1M0 | |
Linux for x64 | 4.4 | | 9.4 TS1M0 | |
HP-UX IPF | 4.4 | | 9.4 TS1M0 | |
64-bit Enabled Solaris | 4.4 | | 9.4 TS1M0 | |
64-bit Enabled AIX | 4.4 | | 9.4 TS1M0 | |
Microsoft® Windows® for x64 | 4.4 | | 9.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.
Type: | Problem Note |
Priority: | medium |
Topic: | Data Management ==> Data Sources ==> Information map Query and Reporting ==> Interactive Querying Query and Reporting ==> OLAP (Online Analytical Processing) Query and Reporting
|
Date Modified: | 2010-07-08 17:02:36 |
Date Created: | 2010-07-08 16:37:18 |