COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Tseug on 10 Jul 2009 10:44:16 AM

Title: Insert blank line in report - SOLVED
Post by: Tseug on 10 Jul 2009 10:44:16 AM
Hello!  If in my filter I'm trying to pull data from ABC and "B" doesn't have any data, the report will return info for A and C.  How can I return a blank line, or even a line with a filler character, for the missing B data?
Thank you for your time.
Title: Re: Insert blank line in report
Post by: Gopinath on 13 Jul 2009 02:35:41 AM
try

if([Data Item] is missing) then (' ') else ([Data Item])