I suggest the following solution.

- set your default value 'ALL' for parameter

- add if statement to Select Expert:
If {?Parameter}='ALL'
Then {Database.Field} like '*'
Else {Database.Field} = {?Parameter}

Then when asked for parameter, just write (or select from drop down list) ALL to get all records.

Works perfectly, Thanks very much for your help

What I did...
When creating a parameter field [?] I used the value type String.
Click the button that says "Set default values"
There is a text box that says "Select or enter value to add"
Type in ALL and click the > arrow.
Add any other values.
you ar edone.

I am several version behind you. I am running V9. I am assume that if you look somewhere in the parameter field setup ox for some value related thing you might find what your looking for. I am no longer of use.

This really helped me but i do have another question.  I am trying to do this with two variables.  This is what i have in the formula editor in the select expert:

If {?Tech} = 'ALL' Then {Command.TECH} like '*' Else {Command.TECH} = {?Tech}
AND
If {?Agent}='ALL' Then {Command.AGENT} like '*' Else {Command.AGENT} = {?Agent}

If I select ALL for one and then specify the other it works fine but if i do it the other way around it shows all of both.  Any help would be greatly appreciated.


Edited by bradschi - 02 Apr 2009 at 12:16pm