Skip to Content
Jan 14, 2013 at 01:50 PM

Problem with empty strings in WebI report



I have a WebI report that is filtering on several fields. One of the filters uses a 'Less than or Equal to 2' condition.

A lot of the records have an empty string (not a null) for this field. The report is ignoring them, but it needs to include them.

Is there a way I can modify the WebI filter to include the empty strings? Or is there a way that the BeX Query can be modified to convert these values to zero?

Thanks for your help!