In some scenarios, data source filters that are based on a calculated item (which is based on parameters) might not return expected results in report objects.

For example, in the following report, when you click Sales in the button bar, the expected behavior is that all report objects display values. When you click Purchasing, report objects display no values.

The calculated item (called Filtervalue) contains the following:

The data source filter contains the following:

However, when you click Sales in the button bar, the Key Value displays correct values, but other report objects are empty.

If you save the report with the Sales value selected in the button bar and you switch to Viewer, all report objects show values.

As a workaround, you can add an expression similar to the following in the data source filter:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Visual Analytics 7.5 is available at: