IBM Support

Active Report with Visualization showing empty categories on edge

Troubleshooting


Problem

Linking a Vizualization to a control in an Active Report shows categories on the edges that have no data. For example in the Samples packages there's no Q4 in 2013. However if 2013 is selected from a dropdown a clustered bar Vizualization in the report will show an empty bar for Q4.

Symptom

Nulls on the edge

Cause

Filtered Data property not set

Resolving The Problem

Select the Axis you wish to change the setting for. In the Properties pane, set the Category Range property to Filtered Data.

Now the report when executed should not show the blank categories on the Axis

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Authoring v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22003021