Prompt for report variable?

[hendy_(Guest)]

Can anybody help me create a prompt or pop-up box in version 8 that will ask the user to fill in some kind of parameter before running a report? For instance, if I want the user running the report to enter in a STATE code, they would get a prompt to fill in "CA" for California and the report would only show those employees?

[kfleming]

In Version 8 we did not have parameteRR fields so you need to use an RIPARAM calculation along with setting a prompt string in your control file.____So in the report you would create a calculated field called PICKSTATE with the expression:__RIPARAM("PSTATE")__and in your query you would:__Include all records where STATE is equal to PICKSTATE.____If you are using a text control file to run the report via runtime you would add a line in control file that says:____PSTATE=?Please enter a state____when the report is run through runtime, the user will be given a prompt box that says Please enter a state.__And whatever they enter will be used in the query.____Note that you have to use runtime and there is no built in error checking of the user^s entry.____If you upgrade to the latest release, this is all MUCH easier. You just create a parameteRR field and then can prompt the user both via runtime and within the report designer itself.____Kathleen__R&R Support

[hendy_(Guest)]

Thanks for the help-__Can you tell me how to use a text control file?

[kfleming]

It is in the documentation/help file under developing applications/using the report viewer executable.______Kathleen