report with a field not in any table possible

WillC

Registered User.
Local time
Today, 09:52
Joined
Aug 18, 2011
Messages
17
I was wondering the easiest way to create an unrelated field that the user can just input data on opening of report and it will be displayed on the report. I want to be able to open a report and a user is prompt to enter a string or choose an option (it is current status where it can only be red/amber/green) that is then displayed on the report, the data doesn't need to be stored in a table as the user decides when report is opened and it can change every time, is this possible? what is the best method if not, thanks
 
In the report add a calculated field. Inside the text field you type what you like, for example [Please enter the year and Quarter]. This must be Between square brackets!
When the report opens, the user will be prompted, and he/she can enter text.
It will be visible on the report.
 
Just Go To the DATA SOURCE of your report and invoke a query so that you can edit or even make your own Data Entry without any relation from a table or field. For Example: In the Query Builder, "Like [Enter (Value)]" put this under the field you want to be filled up, this will allow you to input data on opening your report. (Value) is the textbox you want to be filled up..
 
Last edited:

Users who are viewing this thread

Back
Top Bottom