Changes

Jump to: navigation, search

Prompting for Criteria in Reports

531 bytes added, 18:35, 8 December 2014
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==
8,849
edits

Navigation menu