Changes

Jump to: navigation, search

Including Criteria in ReportProperty

634 bytes added, 14:04, 25 September 2013
no edit summary
:* '''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
 
==Syntax for passing multiple parameters to a report==
:<font size=3>@ReportProperty(12345,exportdata,,"criteria1::criteria2")@</font>
or
:<font size=3>@ReportProperty2(''reportid'',''property'',,"@''criteria1''@::@''criteria2''@")@</font>
 
'''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|Advanced Export]] settings of the Report
* ''criteria1'', ''criteria2'', etc. are the variable that returns the answer to the ??? prompts in the report referenced by the reportid. ''Criteria1'' is matched against the first instance of the ??? prompt in the [[Report Builder]], ''criteria2'' is matched against the second instance, etc., working from left to right.
'''Example''':
8,849
edits

Navigation menu