Skip to main content
Planview Customer Success Center

Some grouped configurable fields in Report Designer report are not expanded(CP2012 SP2)

QUESTION:
Why in Report Designer reports, when I have grouped items, sometimes the values are not expanded or displayed when I click on a given item?


ANSWER:
When using grouping, Report Designer is looking for the values of all items of the previous line. If there is NULL value in the previous line, in a configurable field for example, nothing is listed underneath.

The solution is to create a custom field in the data collection and use the following code to replace NULL values:


ISNULL( [<< the udf to be used >>] ,'')

where << the udf to be used >> is the name of the UDF field.