This content has been marked as final. Show 3 replies
I would suggest adding Right Padding to the column values in the Results tab if there is only formatting significance to your requirement. If there is other significance, please explain so someone can better assist you.
Please award points if helpful/correct.
I think I could not clarify my concern. Apologies for that. We do not have any formatting issue. We are using the field in a Prompt with operator as 'is equal to/is in'. So when the query gets formed, the where clause is coming as -
field _name = 'abcd'
whereas we want it to be
field_name = 'abcd '
Because in the database our value is 'abcd ',as the datatype is char.
We could find a resolution to use 'Contains any' operator instead. But there are hundreds of reports using this field in prompt. Also there is some reason the application do not want to change the datatype in databse to varchar. I needed to know if somehow we can retain the blank spaces in presentation layer.
I think "space_supported" (by default its unchecked)is the parameter u r looking for .(physical layer - > DB features)