8,849
edits
Changes
→Using the Same Criteria Multiple Times
==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==