To change the saved report’s output:
1.Open Business Intelligence and Reports from the Desktop.
2.Select the Saved Reports tab.
The Saved Reports|Reports page appears.
3.Search for and select the saved report that you want to run.
The Saved Reports|Parameters page appears.
4.Enter the criteria with which you want to run the report.
5.Expand the Schedule Saved Report section.
6.Select an output type from the 'Target' dropdown:
Email
Email the report/extract to multiple recipients in multiple formats at once.
a.Email Address: Enter the email address of the recipient.
b.Email Subject / Email Message: Enter a subject and message, respectively.
|
Information
When emailing an HTML report links and images will not function.
|
c.Format: Select the appropriate format for the report/extract (AVDOC, CSV, HTML).
|
Save the report/extract to a specified server.
a.Before you can use this option, you need to set up a target destination.
b.Target Name: Select where you want to send the report/extract.
c.Target File Name: Enter the name that you want the report/extract to be saved as.
You can also add the following to the file name:
•%d: The date will be added to the file name in the YYYYMMDD format.
•%t: The time will be added to the file in the HHMMSS format.
d.Format: Select the appropriate format for the report/extract (AVDOC, CSV, HTML).
After you save the report/extract, the field will display instead, allowing you to verify the URL
|
Print the report/extract to a local or network printer.
a.Printer: Select a printer.
b.Format: Select the appropriate format for the report/extract (AVDOC, CSV, HTML).
|
Save the report/extract to an FTP site with secured/encrypted delivery (SFTP).
a.Before you can use this option, you need to set up a target destination.
b.Target Name: Select where you want to send the report/extract.
c.Target File Name: Enter the name that you want the report/extract to be saved as.
You can also add the following to the file name:
•%d: The date will be added to the file name in the YYYYMMDD format.
•%t: The time will be added to the file in the HHMMSS format.
a.Format: Select the appropriate format for the report/extract (AVDOC, CSV, HTML).
After you save the report/extract, the field will display instead, allowing you to verify the URL.
|
7.Click 'Execute'.
Report Formats
While selecting a report’s output, you can also choose the report’s format:
•AVDOC: Formats the report as a PDF (portable document format).
•CSV: Formats the report as comma separated values (CSV). This allows you to view the report in programs like Microsoft Excel.
•HTML: Formats the report as hypertext markup language (HTML), the standard markup language for creating website and applications.
•application/JSON: Formats the report as JavaScript. This allows you to more easily consume report data for dashboards, data warehouses or other sites or system functions.