I have a report and I want to put a field on that report that a user enters into a prompt. Is there a way to do that at all? I want to prompt a user to enter a field and then put the value of the entered field into a report.
Thanks.
Thanks.
Add a value from a prompted field to a report (1 Viewer)
- Thread starter jeo
- Start date
statsman
Active member
- Local time
- Today, 06:09
- Joined
- Aug 22, 2004
- Messages
- 2,088
Two ways:
First - if you are using a query, set the parameter in the criteria of the query field. Example: field=state in Criteria place [Select State:]. When the report opens it will prompt you for the state.
Second- If you want a prompt for somthing thats not in the report, place a text box into the report (works best in the Header section) with your prompt in the text box. Example: [Date of Report:]
First - if you are using a query, set the parameter in the criteria of the query field. Example: field=state in Criteria place [Select State:]. When the report opens it will prompt you for the state.
Second- If you want a prompt for somthing thats not in the report, place a text box into the report (works best in the Header section) with your prompt in the text box. Example: [Date of Report:]