In the data model, LOOKUP_CODE has 'single character space' , and in the report the column content becomes a null value or it is automatically trimmed in the report.
Please see the attachment.
How to preserve the single space character in the report?