While developing a tabular report, its always flexible if the output is generated in an excel spread sheet format. It becomes easy for the user to perform manipulations and other data comparisons.
So, often the customer demands for an excel output from the oracle reports concurrent program.
Here is the sequence of setup steps to create a report in excel format:
- Create Printer file (.prt)
- Create Oracle report and specify appropriate printer codes for the fields
- Define Printer Driver
- Define Printer Style
- Associate Printer Driver and Style to a Printer Type
- Associate the Printer Type to the Printer
- Define concurrent program and specify the report style created
- Run report and save the output as text file and open it with excel format.
