How to control NULL values in Active reports

[Gnani]

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....

[MFGF]

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.

[Gnani]

Hi MF,

Let me know what more details you are looking for.


Thanks,
Gnani

[MFGF]

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.