0
edits
Changes
no edit summary
This article describes the [[Variables]] that can be used to display report data, or properties of reports. '''ReportProperty''' variable For details on [[Variables]] that can be used to display when creating reports see [[Using Variables in the number of records within a specified reportReport Builder]].'''
'''Where:'''
* ''reportid'' is the system ID for the report (see [[Determining the reportid]])
* ''property'' can be:
:* '''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|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==
'''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)
@ReportProperty(12345,recordcount)@
* To display the number of records at a given status in a Portal Icon::[[Image:CMPortal.png]] Will display as::[[Image:PIcon.png]] ==CSV Data==When using the '''csvdata'''This 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 as [[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 VariableVariables]] to display custom field, or be included in the body of a record count[[Workflow]] message.'' Most often '''exportdata''' is used with report export settings defined as HTML. ==Export Raw Data==When using the Exportrawdata report variable, as part of 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 [[Submit LogicCustom Field Type: Read Only – System Variables|Read Only - System Variables]]custom field, or be included in the title body of a [[PortalWorkflow]] shortcut to indicate how many records are at a given status message.'' ==Notes== * When using any of the ReportProperty variables (for examplerecordcount, 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]]
