;
Exporting a Report into Excel
Exporting a Report into Excel

_NR_Est Tim:

_NR_Test Set:
Exporting a Report into Excel

Test Results
Exporting a Report into Excel

All of the Standard Oracle Reports open in a browser window and have the capability to be exported into Excel.

When the report has completed the request process and the Phase = Completed and the Status: Normal, we are now able to review the report.


Click the View Output button to review the report (RU Revenue/Expense-3 Selections Report).

Click the Save As... menu option.

Select the location that you would like to save the report to.

For this example select the Desktop button.

Click the Save button to save the report as a text file.

click the windows Start menu button.

Click the Office Button button to open the text file that was saved to the Desktop earlier.

Click Open from the menu.

Click the Files of type drop down list.

Select All Files (*.*) from the drop down list.

Select the location that you save the text file to. 

For this example, click the Desktop button.

Select the file name: RU_Rev/Exp_Report.txt from the desktop.

Click the Open button.

Select Fixed width as the Original data type.

For this example leave the data preview with the break lines as the default.

Click the Next > button.


Note: The default break lines can be moved, deleted or new lines can be created as needed by clicking on them or dragging them.

Click the Finish button.


Note: Default Column data format: General - leave as is for this example.

Click the File menu.

The standard report opens in a browser window.

In the File name field enter the name you would like the report to be saved as. For this example enter a valid value e.g. "RU_Rev/Exp_Report".


Note: Leave the following fields as the default:

Save as type: Text File (*.txt)

Encoding: Western European (Windows)

The report is now saved in the location you chose, For this example we saved the report on the Desktop so we will now navigate to Excel to find the file and complete the export.

Click the Microsoft Office Excel 2007 from the programs list.

Microsoft Excel will open a new workbook.

Modify the report in excel by expanding the columns and moving the figures around as needed.

Exporting a Report into Excel

Click the View Output button.
Press [Alt+p].
Click the Save As... menu.
Press [A].
Click the Desktop button.
Click the Save button.
Press [Alt+S].
Click the Start button.
Click the Office Button button.
Click the Open menu.
Click the Files of type: list.
Click the All Files (*.*) list item.
Click the Desktop button.
Click the RU_Revenue_Expense_3_Selection_080909.txt list item.
Click the Open button.
Click the Next > button.
Click the Next > button.
Click the Finish button.
Click the File menu.
Enter the desired information into the File Name field. Enter
a valid value
e.g.
"RU_Rev/Exp_Report"
.
Click the Microsoft Office Excel 2007 list item.
Frame ID:
 
Frame ID: