Urgent,

I created a CR  through a SQL Command. I have a problem while export the results into EXCEL. Let’s assume I have 3 fields A,B,C.

When the report export If A,B,C has values the format is showing correctly.

If A has the value, B don’t have value, C has value – in this case the value of C is showing under B column(formatting issue).

Could you please advice how to handle this.

I tried in SQL by putting

CASE WHEN <filed1> IS NULL THEN ' ' ELSE TO_CHAR(field1) END as field1,

I’m getting formatting with this.

I also tried as:

---------------

CASE WHEN <filed1> IS NULL THEN '.' ELSE TO_CHAR(field1) END as field1,

This is working correctly but it will show ‘.’ On the report if the value of the fields is null. But I don’t want to show any ‘.’.

Please advice,Thanks