I have developed prompts in my universe and need to clear each prompt in my full client report each time it is requested. Is there a ways to clear prompts in a report. It always holds the last entered value?
pcerbus (BOB member since 2002-10-01)
Hi,
you have two ways how to do it:
- Purge all dataproviders where there is any prompt. Save the report and distribute it among the users.
or
- Use VBA to set the default prompt value. Some examples can be found for example here
Marek Chladny 
(BOB member since 2003-11-27)
We do a combination of purging and also pre-filling with a ‘help’ text to the report user (e.g. Enter part number or blank), the help would be text that obviously wasn’t in the database but is easier to look at than blank fields.
MAKM 
(BOB member since 2006-06-07)
Hey p-
Try doing a SAVE AND CLOSE on the query panel for each data provider that uses your prompted objects. I believe it clears out the prior prompts
Chris Pohl (BOB member since 2002-06-18)