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.

• ← Older edit
• Newer edit →

Sartaj

15

edits