SI_INSTANCE Property

A Boolean value specifying whether or not the Crystal Enterprise object is a report instance. Indexed. Read-Only.

Type

Boolean

Syntax

SELECT

    SI_INSTANCE

FROM

    CI_INFOOBJECTS

WHERE

    SI_ID = ObjectID

The syntax has these parts:

Part	Type	Description
ObjectID	Long	A number that identifies the object you want to retrieve.

Used to access the property from a query result:

QueryResult.Item(Index).Instance

Remarks

This property can be used to find all instances of a particular report. When a report is scheduled to run on a recurring basis (for example, hourly), two instances are created: a runnable instance, which is able to run and create another instance, and an instance object, which is the result of a job that has already run. Use the SI_RUNNABLE_OBJECT Property to retrieve only those instances that are runnable, and use the SI_INSTANCE_OBJECT Property to retrieve only those instances that have already been run.

The following select statement retrieves the name and ID of all instances belonging to a report that has the ID 215. The ID value was chosen arbitrarily as an example.

SELECT
    SI_NAME, SI_ID 
FROM 
    CI_INFOOBJECTS 
WHERE
    SI_PARENTID = 215 and SI_INSTANCE=1