COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: sg24 on 20 Jan 2011 06:08:05 AM

Title: eliminating null records
Post by: sg24 on 20 Jan 2011 06:08:05 AM
Hi,
I have report where i am getting blank records (null values) . In one of the column i get "()" as the value.

Kindly tel me how to eliminate the null records.

Please help.

Thanks,.
sg
Title: Re: eliminating null records
Post by: MFGF on 20 Jan 2011 11:23:49 AM
Assuming you are using a relational package, try adding a filter with an expression like

[your value item] is not null

MF.