8,849
edits
Changes
→Using the Same Criteria Multiple Times
3. Click the '''[[Report Builder]]''' tab.
4. Open the Report Builder Help Panel and click on the '''[[Report Builder Column Settings|Special SmartSimple Criteria Values]]''' tab.
[[Image:ReportBuilderHelp-SSCriteriaValues.PNG|link=]]
There are three four special functions displayed.
:{| border="1" cellpadding="5"
11. '''Close''' the current report.
==Using the Same Criteria Multiple Times==
You might want to build a report that uses the same criteria multiple times. For example, a report can prompt the user to enter a date value:
[[Image:ReportsPromptingForDate.png|link=]]<br />
When the report is run, the user will be prompted to select a date value:<br />
[[Image:ReportsPromptingForDatePrompt.png|link=]]<br />
But if the report should display all grants where the date specified is the ''Start Date'' OR the ''Approval Date'', the report would be configured as follows:<br />
[[Image:ReportsPromptingForTwoDates.png|link=]]<br />
This would result in two prompts unnecessarily being displayed to the user:<br />
[[Image:ReportsPromptingForTwoDatesPrompt.png|link=]]<br />
The solution is to use the ''@arg1@'' syntax. Entering ''=@arg1@'' as the second criteria will mean that the system will re-use the user-entered criteria for two comparisons:<br />
[[Image:ReportsPromptingForTwoDatesUsingArg1.png|link=]]
{{MultipleCriteriaVariableSyntax}}
==See Also==
* [[Passing Prompt Criteria to a Sub-Report]]
* [[Criteria Template]]
{{PrevNextStart}} [[Specifying Multiple Criteria in Reports]]
{{PrevNextMid}} [[Prompting for a Criteria using a Wildcard]]{{PrevNextEnd}}
[[Category:Reports]][[Category:Criteria]]