Difference between revisions of "Report Variables"
From SmartWiki
(→'''Important''') |
|||
| Line 26: | Line 26: | ||
=='''Important'''== | =='''Important'''== | ||
| − | * the ''recordcount'' property does not work if your [[Report]] includes '''Group By''' | + | * 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. |
[[Category:Variables]][[Category:Reports]] | [[Category:Variables]][[Category:Reports]] | ||
Revision as of 12:46, 23 December 2009
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.
