Run Time prompt

[Pam_Morrow_(Guest)]

We^re having trouble figuring out how to create a "run time prompt" in the R & R Report Writer. We need to create a prompt for users to be able to enter a date range each time the report is run. Something like this:_____Enter Beginning Order Date:_(user entered date)_____Enter Ending Order Date:_(user entered date)____The report would then only print data for orders with dates within the range entered.____We^re looked through all the help menu^s and can^t figure out how to create these fields. ____Thanks for any help you can provide.____Pam Morrow__Dioptics Medical Products, Inc.__

[kfleming]

If you are using Version 9 and above, you can create a parameteRR field. You just create the parameteRR field, use it in your query and then when the report is run you will get a parameterr value entry screen to enter the start and end dates and those dates will then be used to select the correct records.____Prior to V9, you need to create a calculated field that uses the RIPARAM function and then add a field to your control table to prompt for that value. And since RIPARAM returns a character string, you would need to convert that string to a date field using the CTOD function.______Kathleen__R&R Support__

[Danielrunny]

We are on a version prior to V9. The information you provided makes sense but we can^t figure out how to add a field to the control table. Where is the control table located?____Pam Morrow