Report Variables

This article describes the Variables that can be used to display Reports, or properties of reports.

For details on Variables that can be used when creating reports see Using Variables in the Report Builder.

This ReportProperty Variable can be used to display the number of records within a specified report.

This can be used:

• In a Web Page View or as a Read Only - System Variable to display a record count
• As part of Submit Logic to ensure a certain condition is met prior to submission of a record.
• Included in the title of a Portal shortcut to indicate how many records are at a given status (for example)

Syntax:

@ReportProperty(reportid,recordcount)@

Where:

• reportid is the system ID for the report (see Determining the reportid)

Examples:

• To generate the number of records (equivalent to the number of rows in the report) for report with ID 12345

@ReportProperty(12345,recordcount)@

• To display the number of records at a given status in a Portal Icon:

Will display as:

Important

• the recordcount property does not work if your Report includes Group By. It can only be used to count the records in a report based on filtered criteria.