Changes

Report Variables

180 bytes added, 13:44, 9 May 2013
This edit is for adding the syntax to be used when using ReportProperty on a report which has a group by clause.
:* '''exportdata'''- Report data, formatted as defined in the [[Exporting Reports|Advanced Export]] settings of the Report
'''Note:''' :* ''ReportProperty'' is case sensitive. Using ''reportproperty'' will not work.:* 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.<pre>@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))@</pre>
You can also pass '''criteria''' into the ReportProperty call. See [[Including Criteria in ReportProperty]].
Will display as:
:[[Image:PIcon.png]]
 
 
'''Important: ''' The ''recordcount'' property does not work if your [[Report]] includes '''Group By'''. It can only be used to count the records in a report based on filtered criteria.
15
edits