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

Insert blank line in report - SOLVED

Started by Tseug, 10 Jul 2009 10:44:16 AM

Previous topic - Next topic

Tseug

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.

Gopinath

try

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