COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kirru_alayam@yahoo.co.in on 21 Nov 2013 03:00:13 PM

Title: How to pass to null values in drill through report
Post by: kirru_alayam@yahoo.co.in on 21 Nov 2013 03:00:13 PM
Hi,

I created a list report and passing parameters to child report. but when i am passing the parameters from master report my child report is not getting perfect data. I have a null value when i am passing parameter to child.

Scenario1.

A        B       C      D         E       D1       D2
---------------------------------------------------------
a        b        c      d        null     10       20 

Scenario2.

A     E       D1       D2
--------------------------
a    null     10       20

in the above scenarios i have a applied drill through on A and passing A Data Item and B,C,D,E  parameters to child

but not getting any values in child report for that.

for master report i have created a value prompts for A, B, C, D, E and given static choices. for E i have not given anything in Use and for Display purpose i have given Null. In master report i am getting null values. but when i clicked on A for drill through child report this blank is not passing to child and not getting any output.

Please advice

Thanks,
Kiran
Title: Re: How to pass to null values in drill through report
Post by: CognosSteve on 22 Nov 2013 05:58:51 PM
You probably want to clean up null values.  Have you tried cleaning up null values and defaulting those to something else like zero or some other value?