report out put style in xl format

[anandraoapps]

hi ,

how can we get a report out put style in xl/spred sheet format

[sridhar_6735]

Oracle offers a solution that enables our Oracle E-Business Suite Customers to turn the once unfriendly and useless Oracle seeded reports into PDF and XLS outputs of color, graphics, and tables. The solution is XML Publisher. XML Publisher is a java based reporting tool that is bundled for free within the technology stack of the Oracle E-Business Suite. The concept is similar to that of ?mail-merge? where the data and template are maintained separately until the two are ?married? to generate the desired document. XML Publisher separates a report?s data and layout component into two manageable pieces while it supports the desired outputs of PDF, HTML, XLS and RTF. The prerequisites to use XML Publisher include:

* XML Data
* Report Template
* Registration of Data Definition and Template at XML Publisher

How does XML Publisher leverage on Oracle seeded reports? An Oracle seeded report is a report definition file that integrates both the data query and the report layout into one file. XML Publisher will use Oracle Reports for only the data query portion and will ignore the defined report layout. This will fulfill one of XML Publisher?s prerequisites: XML Data. So the question is, how do you set up the Oracle system to only use the data query portion of the Oracle report?

*
Log into Oracle with System Administrator Responsibility
*
Navigate to > Concurrent > Program > Define
*
Search for the desired Oracle Report
*
Change the Output Format from the default ?Text? to ?XML?
*
Take special note of the Program Short Name (you?ll need it later to register the data at XML Publisher)