8,849
edits
Changes
no edit summary
* ''criteria'' is the answer to the ??? in the report referenced by the reportid
'''ExamplesExample''':
* The report with reportid 12345 has a [[Prompting for Criteria in Reports|criteria]] on a date field of "=???"
* To generate the number of records in the report with a date of 2009-10-26:
==Syntax for dynamic static parameters to a report==
:<font size=3>@ReportProperty2(''reportid'',''property'',,"''@criteria@''")@</font>
:* '''csvdata''' - Report data, with each field separated by commas
:* '''exportdata'''- Report data, formatted as defined in the [[Exporting Reports|Advanced Export]] settings of the Report
* ''criteria'' is the variable that returns the answer to the ??? in the report referenced by the reportid '''Example''': * The report with reportid 12345 has [[Prompting for Criteria in Reports|criteria]] on a date field of ">=???" and "<=???"* To generate the number of records in the report with a date range of startdate to enddate: @ReportProperty2(12345,exportdata,,"@year(fullstartdate)@-@month(fullstartdate)@-@day(fullstartdate)@"::"@fullenddate@")@
==Notes==
* When using any of Do not use single quotes to encapsulate criteria.* Note that if the ReportProperty variables (recordcountvariable is used on a web page view, exportdata and csvdata) the object ID ([[opportunityid]], [[eventid]], [[userid]], etc) report will be passed to run every time the report processorweb page view is opened. If the specified report includes the variable: '''@''objectid''@'''Therefore, it will use this functionality sparingly or server performance may be replaced by the object ID of whichever object (Level 1, Level 2, Contact, etc) called the ReportProperty attributeimpacted.