Formula...One or All

[memickee]

Help!
I need to create a formula for select expert to handle a paramter that will return one specific record when the correct info is passed and when the parameter is empty to return all records.

Thanks

 

[TheBlondOne]

Hi memickee,

I used something similar formula a while ago. It goes like this.

if {?Parameter Name} = "" then true else {?Parameter}

Alternatively could you not create a wildcard in the parameter?.

Hope this helps

 

[FoxG]

Hi,

You can use * in your parameter value for all.
Then change the expression to {field} like {?parameter}

Hth,
Geoff