Oracle Analytics and AI

Sampath Kumar Chanda

Summary

XML report in EXCEL showing output in left/Right allignment

Content

Hi Team,

 

I have issue in XML report

1.Using report SQL has been build to generate XML

2.template has designed as well for the same

3.output format EXCEL

4.we are able to generate report but invoice number left alligned when its starts with Alphabets

    right alligned when it starts number

5.Requirement is to allign both on left side - can you please suggest any solution

 

--please find attached screenshot for reference

 

Thanks

Sampath

Justin Malloy

Isn't that an excel issue? It formats char vs. numerical that way. Did you try changing the data-type? (just spitballing ideas at the moment, since no one else has responded)