If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to pass to null values in drill through report

Started by kirru_alayam@yahoo.co.in, 21 Nov 2013 03:00:13 PM

Previous topic - Next topic

kirru_alayam@yahoo.co.in

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

CognosSteve

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?