Greetings!
I am trying to find a way to allow a user to add a free-form text block onto the report. Basically it is an optional way to give a couple people with really bad handwriting an excuse to not have to write on the report with a pen. The problem is I am at a loss for how best to do this.
Here is what I am looking to do:
[list]Optional prompt[/list][list]1-2 sentences[/list][list]Does not need to persist after printing[/list]
Is there an easy way to do this? I found this option from 2010 to add Excel-like comments but that is not what I am seeking.
Can I just add a variable, prompt for that variable, and print the results? Am I over thinking this?
…but by using a prompt, this means you need to refresh / open the report to see the data, then refresh again in order to surface the prompt entry screen and make your notes to include via =userresponse(prompttext).
Using an input control prevents unnecessary refreshes, you can just add your notes to the text box.
I took the idea of the Input Control back to the customer but they were adamant about wanting the prompt for some reason.
I tried creating a variable and assigning the variable value to a blank cell on the screen similar to this but I could not get the variable wired up to actually prompt the user.
I finally found something that worked but it is kind of a hack and situational. The report was already filtering on a specific column for a given type (ProductName = RawMaterial). I added a second filter for ProductName and set it to be not equal to the prompt. If nothing is entered then the first part of the AND works and all RawMaterial is returned. If something in the prompt is entered then that value is used as the optional footer/notes. This is a total hack but it solved the problem.
B!
(BOB member since 2008-10-09)
(BOB member since 2008-10-09)