No matching occurs

[dideb]

Hello All,

I created a report using BO 6.5.1 accessing a SQL Server database. This report is then published to InfoView,
In this report I have a prompt on a Column having a datatype of nchar.
The prompt is like this:
Where A.Reference2Vendor LIKE @variable('Contract Number:')
The problem is that most of this column's values is spaces ' '. So, in the prompt on the InfoView if I choose "Show Values" and select the empty value no matching occurs. As if the InfoView truncates the spaces....
Any Ideas?


Thank you,

Diaa

 

[BrianTyler]

You could change the object in the universe so that the value of spaces is converted to some other string.

 

[blom0344]

Something like:

CASE WHEN Contract_Number = '               '
THEN RTRIM(REPLACE(SUBSTRING(Contract_Number,1,1),' ','X'))
ELSE Contract_Number END

or something along those lines...

Ties Blom
Information analyst