Report Variables
From SmartWiki
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.
Syntax:
- @ReportProperty(reportid,property)@
Where:
- reportid is the system ID for the report (see Determining the reportid)
- property can be:
- recordcount - Count of the number of records within a specified report
- csvdata - Report data, with each field separated by commas
- exportdata- Report data, formatted as defined in the Advanced Export settings of the Report
recordcount 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)
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.
