User Input at Runtime

[srappaport]

What is the preferred way to allow run-time users to select:__- filter criteria prior to running a report?__- date ranges for a report?____How do I as a nonprogrammer make it possible for them to do the above? ____Thanks.

[kfleming]

You can present users with the filter dialog at runtime by setting RI_QUERY to a ? in your control table.____For date range selection, the easiest thing to do is to create two date parameteRR fields when you design the report and prompt the user to enter a start and an end date. Then use these parameteRR fields in your query. When the report is run at runtime, the user will be prompted to enter the start and end date. No programming other than creating a text control file and creating a command line to run runtime using that control file.____Kathleen__R&R Support

[srappaport]

Kathleen, your comments are very helpful. I^m beginning to get the idea. ____The documentation is good, but a little too lean for me at my current level of understanding. Some things I can^t find, like the RI_Query you referred to earlier. I^ve searched the online help for SQL 9.0 and all other documentation but without luck.____In order for me to get up the learning curve, I need some tutorials, detailed examples or training. What do you recommend?