1 Reply Latest reply: Jun 11, 2014 9:34 AM by AlexAnd RSS

    Need help XML Publisher report having more columns

    user13424229

      Dear All,

       

      I need suggestion on below scenarios.

       

      I have to develop a xml reports which is having 300 fields, so i need know which approach i need to follow while writing query.

       

      1>Can we write a single query(having multiple subquery) to fetch all data , is it feasible?

      2>Or we need to store all data in a global temporary table and from ther i can pick for my report.

      3>Or we can use RDF having different query and map the corresponding field.

      4>Or inside a PL/SQL package setting the value for the fields and in xml data defination just need to give the value from package.

       

      So please let me know which approach should be easier to develop.

       

      Thanks

        • 1. Re: Need help XML Publisher report having more columns
          AlexAnd

          So please let me know which approach should be easier to develop.

          it depends of .....

           

          first of all it depends which type of template are you using

          for true excel template may be easier one or another based on displaying logic/format and based on logic of retrieving data

           

          i need know which approach i need to follow while writing query.

          any from 4

           

          1>Can we write a single query(having multiple subquery) to fetch all data , is it feasible?

          why not, did you try it ? if no then try and post feedback