Hello,

Raising Enhancement request for SR 3-39715167181 : BI Publisher SQL based report - RPAD fixed length not working in CSV output

We are using RPAD to ensure a fixed-length output. The issue is that when a column has a value, RPAD fixed-length for that column works correctly, but when the column value is NULL, it doesn't work as expected. However, our expectation is all columns to have a fixed length, regardless of whether they contain a value or are empty

Also the generated xml has the spaces. But during report generation in csv, those spaces are ignored if the value has just the spaces. We think that functionality needs to be changed, hence raising an enhancement request . Kindly check and provide an update in timely manner.

Thanks.