Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Jaspire on 08 May 2008 12:45:43 PM

Title: Filter in ReportStudio
Post by: Jaspire on 08 May 2008 12:45:43 PM
Hi All,
I created a report having Prompts and a Filter. The prompts are working good. But when I run the report I am getting all the values in the report including those which have the qantity = 0. But I gave a filter condition with Quantity= 0 .
Can you suggest me any cause why this can happen?

Thanks
Title: Re: Filter in ReportStudio
Post by: almeids on 08 May 2008 01:13:18 PM
(I'm assuming you have a typo in the filter above and don't want the zeroes)
Perhaps the quantities in the database are null rather than 0.
Try filtering with IS NOT NULL or IS NOT MISSING.
Title: Re: Filter in ReportStudio
Post by: Jaspire on 08 May 2008 04:26:54 PM


Thank you
Text only | Text with Images