Prompting for Criteria in Reports
From SmartWiki
Revision as of 16:57, 28 November 2007 by Julia Decker (talk | contribs)
You can prompt the person that runs the report for the criteria, by replacing the criteria string with three question marks - ???.
1. Make a new copy of the current report named – Prompt for Title.
2. Click the Edit button.
3. Click the Report Builder tab.
4. Click the SmartSimple Special Criteria Values tab.
There are three special functions displayed.
5. Replace the current criteria with the criteria shown below:
6. Click the Build Query button.
7. Click the Save button.
8. Click the Preview button.
The Criteria Prompt window is displayed.
9. Type President.
10. Click the View Report button.
Only records matching the entered criteria are displayed.
11. Close the current report.
