How do I create a query studio prompt on a filter to have a static set of values to choose from instead of reaching out to the database to get the options available?
I created a "Pick values from a list" filter and chose "Prompt every time the report runs" options. When the report runs, the prompt page comes up and it takes a long time to load the values for the list. Is there a way I can create a static set of values to choose from ?
I cannot use Report Studio and so the advanced options are available to me.
Thanks in advance!