COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cygnex on 02 Sep 2009 12:05:43 PM

Title: Leading blanks are ignored in Report Studio
Post by: cygnex on 02 Sep 2009 12:05:43 PM
We have a need to create a report that displays any contact's name that starts with a blank, as these are invalid.  It appears that report studio ignores any blank character at the start of a field.  Is there anyway in Report Studio or FM that would allow reports to recognize fields that start with a blank?
Title: Re: Leading blanks are ignored in Report Studio
Post by: twlarsen on 02 Sep 2009 03:06:53 PM
I would check how your FM is setup.  I'm able to report off of blanks in the leading spaces without a problem using filters such as Left(Field,1) =''

Todd