COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Gnani on 13 Jul 2016 03:05:08 AM

Title: How to control NULL values in Active reports
Post by: Gnani on 13 Jul 2016 03:05:08 AM
Hi Cognos folks,
I have an issue on controlling NULL values in active reports.

We have an 'Application Count' measure in active report placed as data deck connected with drop down deck on region column.
But whenever there is no data for particular region 'Application count' is displaying whole count instead of showing '0' or NULL.

Any help guys....
Title: Re: How to control NULL values in Active reports
Post by: MFGF on 13 Jul 2016 03:49:06 AM
Quote from: Gnani on 13 Jul 2016 03:05:08 AM
Hi Cognos folks,
I have an issue on controlling NULL values in active reports.

We have an 'Application Count' measure in active report placed as data deck connected with drop down deck on region column.
But whenever there is no data for particular region 'Application count' is displaying whole count instead of showing '0' or NULL.

Any help guys....

Hi,

Sounds like there's a flaw in your logic somewhere in the report? Difficult to know based on the sketchy details you posted here, though...

MF.
Title: Re: How to control NULL values in Active reports
Post by: Gnani on 13 Jul 2016 04:47:21 AM
Hi MF,

Let me know what more details you are looking for.


Thanks,
Gnani
Title: Re: How to control NULL values in Active reports
Post by: MFGF on 13 Jul 2016 06:17:27 AM
Quote from: Gnani on 13 Jul 2016 04:47:21 AM
Hi MF,

Let me know what more details you are looking for.


Thanks,
Gnani

You need to bear in mind that you are the only person here who knows how your report is built and the detail of how things link together in it. We don't know what variables you have, whether they are selecting or filtering other objects, what master/detail relationships you have etc etc.  You need to describe this in enough detail to allow us to understand what is in the report and how it works, then maybe we can pinpoint what might be wrong with it.

Cheers!

MF.