Report Variables

From SmartWiki
Jump to: navigation, search

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

This can be used:

Syntax:

@ReportProperty(reportid,recordcount)@


Where:


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:
CMPortal.png

Will display as:

PIcon.png

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.