Print Page - Showing Zero instead Null values in cross tab

Title: Showing Zero instead Null values in cross tab
Post by: Gyana on 12 Apr 2012 12:39:32 AM

Hi,
I have a crosstab with Fund,Quarter ant current amount.Page break on Fund.

Page-1

Fund | Q1 | Q2 | Q3 | Q4 |
--------|-----|-----|----- |-------
AAA | 5 | 4 | 2 | 1

Page-2

Fund | Q1 | Q2 | Q3
--------|-----|-----|-----
BBB | 10 | 4 | 5

The report looks like this but my requirement is whenever there is no Quarter it should show Zero (0).
Means In Page-2 it should show Q4 with zero values.

Please guide me .

Thanks in Advance.

Title: Re: Showing Zero instead Null values in cross tab
Post by: blom0344 on 12 Apr 2012 01:56:55 PM

Basically adjust your model / report to fetch all quarters regardless of factdata existing. There are a gazillion posts on how to solve this using outer joins / unions..

Here is one:

http://www.cognoise.com/community/index.php/topic,18430.msg54125.html#msg54125 (http://www.cognoise.com/community/index.php/topic,18430.msg54125.html#msg54125)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Gyana on 12 Apr 2012 12:39:32 AM