Changes

Jump to: navigation, search

Using Variables in the Report Builder

640 bytes added, 21:51, 14 May 2013
m
Added @arg@ variable
==objectid==
* When using any of the [[ReportProperty Variables]] (recordcount, 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.
 
==Referencing criteria entered in the same report==
* If you ever need to reference the user entered criteria within the same report, you can use the '''@argx@''' variable where x = 1,2,3.. depending on what number the argument is. The idea is similar to using @args[1]@ if referencing the criteria within a sub-report but this is for a single report.
 
* This syntax can be used within '''Calculated Field''' and '''Criteria'''.
 
Sample use case can be if you are prompting for a date range in the report, but within another column of the report you want to use the user entered date to further limit the records using date_add, date_sub.
[[Category:Reports]][[Category:Variables]]
0
edits

Navigation menu