If you do not want to or cannot add a record to your master list of Countries of "ALL" go to this link:

You can use it for dynamic parameters as well although I am not sure how to set it up as a default. I tend to use "...All" rather than "ALL" and then sort the list ascending so it is always the first item in the list of options. The "..." makes it first regardless of how many other items in your list start with an A.

Hi again DBlank,

Your logic is sound although I did get errors when I followed your code example - probably table/field naming. But how much overhead delay will this approach give a user with, say, 8 dynamic parameters querying a large SQL Server database over a network I wonder?

In the meantime I am experimenting with something rather more 'rough and ready'. I have found that the dynamic prompt '...' is actually a blank space - not a null nor an ellipsis. So instead of embedding and testing for "...All" I can test for space(1).

So far so good and it will make it a lot easier to upgrade 80 existing CR 8.5 reports replacing "ALL" with "space(1)" in the Select Expert.

If you can see any obvious drawbacks to my approach I will interested to hear from you.

Lastly, I am now faced with the problem of coding for the "startswith" option - which I use extensively as all the dynamic parameter prompts are discreet values and one can no longer enter a single character ???

Thanks again for your help and advice!

Peter Tyler
Geneva - Switzerland