Set filter to run for all

[garfunkal]

Hi,

in 8.4 i have a prompt, and as a default i want to run with the filter off, so all data returns.  However the user may want to change the prompt to filter the data - this is all good, but if the user then wants to unfilter again to return a full list  I'm unsure how to do this!

I assume i need some kind of ALL option in the prompt.  I know I can set up an ALL static option, and then in the query list all the potential options, but that's not very good long term, as new options are added.

Is there a way to add an option for All?  I'm not using a stored proc, so I can't pass a value and set it as null - very frustrating!

any help gladly received

[Lynn]

Can you just make the prompt optional? It will only limit results when the user selects something.

[wyconian]

Or you can have the static choice of all and change your filter to something like item = ?prompt? or  ?prompt = all

The user can then either select something an actual item from the prompt if they want to see specified items or they can select All if they want to see everything.

If they select something from the prompt and then want to run the report for everything they will need to reprompt and select All

[garfunkal]

Hi Lynn - that's really good till they want to rerun for all! They are a needy lot

Wyconian - thats sound great. I didn't realise there was an option to do that! I'll give it a whirl first thing.

Many thanks.

[Lynn]

If you select nothing in an optional prompt you will get all.

[garfunkal]

When you rerun won't it default to the last chosen value? Regardless at for your help. It seems do-able

[garfunkal]

Or you can have the static choice of all and change your filter to something like item = ?prompt? or  ?prompt = all

The user can then either select something an actual item from the prompt if they want to see specified items or they can select All if they want to see everything.

If they select something from the prompt and then want to run the report for everything they will need to reprompt and select All

this worked like a dream!  thanks so much