Retrieving a list of report instances

When retrieving a list of report instances, a query is made for the following properties: SI_ID, SI_PROGID, SI_SCHEDULE_STATUS, SI_RECURRING, SI_OWNER, SI_UPDATE_TS, SI_PROCESSINFO.

Note:    For a description of each property, see the Query Language Reference.

The GetObjectIndex function in paging.csp is used to retrieve the instances and store them in an array. Because an instance is a report object's child, the query uses SI_PARENTID as a condition in the WHERE clause to retrieve all of the instances that belong to a particular parent object.

Once the report instances are retrieved, the GetStatusString function in is used to determine the status of each instance. If an instance is successful, a hyperlink to the instance is displayed, and its parameter values and format type are shown. Parameter values are retrieved with the Parameters function.

Note:    For information on handling report parameters, see Viewing a report containing specific parameter values.