Export Excel Report without Business Reporter
Explanation
This activity is used to save and/or email the generated Excel report without
attaching Business Reporter functionality. You can save the Excel report on the local disk, send the excel report to email recipient (MS
Office Outlook) or do both.
The Excel report without Business Reporter
functionality is exported for two main purposes.
- To distribute the report to users who do not have Business Reporter installed.
- To allow users to enter new data or modify existing data in the
report. The modified report can be imported back to the Business Reporter report and then moved
to the IFS database using the writeback feature of Business Reporter.
Once the Excel report is exported you can save the executed report with Business
Reporter functionality in the Business Reporter export archive and/or in the local disk. This Business
Reporter report can be
used as the base to import external data from an updated version of the exported
Excel report without Business Reporter. The saved reports can also be used for later reference.
Prerequisites
In order to perform this activity:
- An executed Business Reporter report must exist.
- If the excel report is exported in order to be used for later
import, the original Business Reporter report should have one or more writeback enabled cells
(since data can be imported only for writeback enabled cells).
System Effects
As a result of this activity,
the following system effects would take place
depending on the method of export selected.
Method |
System Effect |
Save on disk |
The Excel report without Business Reporter is saved in the specified location.
|
Save on disk and email |
The Excel report without Business Reporter is saved in the specified location. In addition,
an e-mail composing window will open in MS Outlook and the Excel report
without Business Reporter will be attached to it. |
Email |
An e-mail composing window will open in MS Outlook and the Excel report
without Business Reporter will be attached to it. |
If you export the Excel report for later import,
the Business Reporter report will also be saved in the Business Reporter export archive irrespective of the method, with
a default expire date of sixty days.
Related Process Models
Export Report
Related Activity
N/A
Procedure
To export an Excel report:
- Execute the Business Reporter report you want to export.
- In the IFS Business Reporter ribbon click
Export to open the Export to Excel Report
dialog box.
- Select either
Export to Excel Report
option or the
Export to Excel Report for Later Import
option in the header of the dialog box.
- Select
either Save on Disk, Save on Disk and Email, or Email
in the Export Excel Report Without BR tab as required.
- If you selected either Save on Disk
or Save on Disk and Email, click Browse to specify the
location in disk where you want to save the report.
- Change
the
default File Name if required.
-
Click Export if you do not want to save the Excel report with Business
Reporter attached. If
you want to save the Excel report with Business Reporter attached, click on the Save BR Report
tab.
Note: If you selected
Export to Excel Report for Later Import option in the header of the
dialog box, the report is automatically saved in the Business Reporter export archive.
Therefore, you will be required to use the Save BR Report tab
only if you want to save the report with Business Reporter attched on your local disk.
-
Select Save BR Report to Archive and/or Save BR Report to Disk
check boxes depending on where you want the report saved.
- If you selected the Save BR Report to Disk check box, enter the
location on disk where the report should be saved in the File Path
field. You can browse for the relevant location.
- Modify the report name suggested in the Report Name field if
required.
-
Click Export.