0
edits
Changes
no edit summary
:* '''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 [[Exporting Reports|Advanced Custom Export]] settings of the Report
:* '''exportrawdata''' - Report data, without any formatting
'''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(op.opportunityid))@
==Export Data==
When using the Exportdata report variable, the variable will be replaced with data from the specified report, in the format defined by the advance custom export template.
:<font size=3>@ReportProperty(''reportid'',exportdata)@</font>
