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

Leading blanks are ignored in Report Studio

Started by cygnex, 02 Sep 2009 12:05:43 PM

Previous topic - Next topic

cygnex

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?

twlarsen

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