0
edits
Changes
no edit summary
This article describes the [[Variables]] that can be used to display [[Reports]]report data, or properties of reports.
'''For details on [[:Category:Variables|Variables]] that can be used when creating [[Reports]] reports see [[Using Variables in the Report Builder]].'''
:* 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)
:[[Image:PIcon.png]]
==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 custom export template.
:<font size=3>@ReportProperty(''reportid'',exportdata)@</font>
''The exportdata 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.''
Most often '''exportdata''' is used with report export settings defined as HTML.
==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==
* When using any of the ReportProperty variables (recordcount, exportdata and csvdata) the object ID ([[opportunityid]], [[eventid]], [[userid]], etc) will be passed to the report processor. If the specified report includes the variable: '''@''objectid''@''', it will be replaced by the object ID of whichever object (Level 1, Level 2, Contact, etc) called the ReportProperty attribute.
==See Also==
* [[Including Criteria in ReportProperty]]
* [[Using Variables in the Report Builder]]
[[Category:Variables]][[Category:Reports]]