Changes

This '''ReportProperty''' variable article describes the [[Variables]] that can be used to display the number report data, or properties of records within a specified reportreports.

This can be used::* In a '''For details on [[Web Page ViewVariables]] or as a that can be used when creating reports see [[Custom Field Type: Read Only – System Using Variables|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 [[PortalReport Builder]] shortcut to indicate how many records are at a given status (for example).'''

'''Note:''' *:* ''ReportProperty'' is case sensitive. Using ''reportproperty'' will not work. * ===Using ReportProperty on reports with a Group By=== *:* In order to use a ReportProperty on a report which has a group by clause, you need to add a distinct clause to the ReportProperty syntax. * @ReportProperty(''reportid'',''property'',distinct(''fieldname''))@ Example: If a report is grouped by the tracking id, then your ReportProperty syntax would be @ReportProperty(''reportid'',''property'',distinct(opportunityid))@ You can also pass '''criteria''' into the ReportProperty call. See [[Including Criteria in ReportProperty]]. ==Record Count=='''recordcount''' can be used: *:* In a [[Web Page View]] or as a [[Custom Field Type: Read Only – System Variables|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