Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

XML report in EXCEL showing output in left/Right allignment

Received Response
52
Views
2
Comments
Sampath Kumar Chanda
Sampath Kumar Chanda Rank 2 - Community Beginner
in Oracle Analytics Forum

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

Answers

  • Justin Malloy
    Justin Malloy Rank 2 - Community Beginner

    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)

  • Sampath Kumar Chanda
    Sampath Kumar Chanda Rank 2 - Community Beginner

    Hi All,

    I have kept few spaces after tag in xml template issue got resolved

    Thanks

    sampath