Skip to main content
Version: 8.1

system.report.executeReport

This function is used in Python Scripting.

Description

Immediately executes an existing report and returns a List[Byte] of the output. Throws an IllegalArgumentException when any of the following occurs: If the file type is not recognized, path does not exist, project does not exist.

Client Permission Restrictions

This scripting function has no Client Permission restrictions.

Syntax

note

This function accepts keyword arguments.

system.report.executeReport(path, project, [parameters], fileType)

Parameters

TypeParameterDescription
StringpathThe path to the existing report.
StringprojectThe name of the project where the report is located. Optional in client scope.
Dictionary[String, Integer]parametersA dictionary of parameter overrides, in the form name:value. [optional]
StringfileTypeThe file type the resulting byte array should represent. Defaults to "pdf". Not case-sensitive

Returns

List[Byte] - A byte array of the resulting report.

Scope

Gateway, Vision Client, Perspective Session

Values for the fileType Parameter

Acceptable values are:

  • pdf
  • html
  • csv
  • rtf
  • jpeg
  • png
  • xml
  • xls
  • xlsx
xls and xlsx Formats

The xls and xlsx format options may return less than pixel perfect results. This is due to how many spreadsheet programs interpret the resulting file. As a result, the pdf format is recommended in most cases.

Code Example

Code Snippet - Executing Report
# Executes the report, overriding two parameters.
overrides = {"myStringParam":"Hello world", "myIntParam":3}
bytesArray = system.report.executeReport(path="My Path", project="MyProject", parameters=overrides, fileType="pdf")

Keywords

system report executeReport, report.executeReport