COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: stancho on 17 Sep 2013 04:09:13 PM

Title: Show zero values in Line Chart report in Report Studio
Post by: stancho on 17 Sep 2013 04:09:13 PM
Hello,

I have DMR model and outer join between fact table and Date Dim in order to show all of the dates even there is no data for them.
I show the measure in a Line Chart. How to get zero values where there is not data. Currently the line is being broken where there is no value.

I need something like "formatting on the cells in crosstab set the "missing value" to show as 0" but for chart.
This is working for a crosstab but no for a chart.

Thanks,
Stancho