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(opportunityid))@ You can also pass '''criteria''' into the ReportProperty call. See [[Including Criteria in ReportProperty]].
==Record Count==
==CSV Data==
When using the '''csvdata''' report variable, the variable will be replaced with data from the specified report, as comma separated values.
:<font size=3>@ReportProperty(''reportid'',csvdata)@</font>
''The csvdata variable can be used in a [[Web Page View]] or [[Custom Field Type: Read Only – System Variables|Read Only - System Variables]] custom field, or be included in the body of a [[Workflow]] message.''
'''csvdata''' is most often used within the body of a plain-text workflow e-mail.
When using the '''csvdata''' variable the header and footer defined on the [[Report Export]] page will be used.
==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>
==Export Raw Data==
When using the Exportrawdata report variable, the variable will be replaced with data from the specified report, without any formatting applied.
:<font size=3>@ReportProperty(''reportid'',exportrawdata)@</font>
''The exportrawdata variable can be used in a [[Web Page View]] or [[Custom Field Type: Read Only – System Variables|Read Only - System Variables]] custom field, or be included in the body of a [[Workflow]] message.''
==Notes==
==See Also==
* [[Including Criteria in ReportProperty]]
* [[Using Variables in the Report Builder]]
[[Category:Variables]][[Category:Reports]]
