Siebel Object Types Reference > Siebel Object Types >

Sub Report

Siebel Object Types > Report > Sub Report

Manages the child records of a report (where the report manages the parent records). Subreports are specific to Microsoft Access, Actuate, and general reports.

Valid Values/Examples

Business Component (R)

The name of the business component whose data is the basis for the subreport. This business component is linked to the business component of the previous subreport declaration (if any) or the top-level report declaration.

The business component must be declared as the Child business component to the business component specified in the report object. Typically the report object business component is synonymous with a specific business object and the business components that are available to subreport are business components that exist within the business object with a valid link declared. Reports are similar to views in that if the relationship from the subreport to the parent report cannot be configured into a view, then the subreport cannot be used.


Exported Table (R)

(CSSReport and CSSCrystalReport classes only.) The filename or the table that the subreport data is exported to.


Inter Table (O)

The name of the intersection table to use when there is a many-to-many relationship between this business component and the parent business component.


Inter Table Name (O)

(CSSReport and CSSCrystalReport classes only.) The name of the table or the filename that the subreport intersection table data is exported to.

When naming the intersection table, the convention is to use the parent and child business component separated by a slash mark (/).


Position (O)

The ordinal position of the subreport.

The first-level positions are 1, 2, 3, 4, and so on. The next level identifies the corresponding parent of the subreport; if Position is 1, then all successive subreport positions would be 1.1, 1.2, 1.3, and so on.


Search Specification (O)

An additional search expression that can be applied to the subreport's business component.


Sort Specification (O)

An additional sort specification that can be applied to the subreport's business component.


Ordinal Position

The parent-child relationship between subreports is based on the ordinal position of the subreport's declaration. The report object is the first position in the ordinal, so it is 1. Subreports are one level deeper, so they get their own unique ordinal. For example, if you have three subreports, then they are numbered 1.1, 1.2, and 1.3. Subreports where the business component is a child are assigned successive whole-digit ordinals (2, 3, and so on). Subreports to these are assigned ordinals such as 2.1, 2.2, and so on.

See Also

Business Component

Siebel Object Types Reference Copyright © 2006, Oracle. All rights reserved.