Help with exclude parameter with show "None" as default 1

[jeffm777]

Working on a report and I need a parameter to exclude certain conditions from a class. The problem is there will be some times when I don't need to exclude any conditions. Is there a way to add an exclude "none" option as the default?

 

[lbass]

I would handle this by using prompt text with tells the user to enter "None" if there are no conditions to be excluded. You don't have to address this in your selection formula since this will work as long as the data you are checking with the parameter doesn't include the word "None".

You could also add the word "None" as the default value in the parameter setup screen.

-LB

 

[jeffm777]

Thanks lbass. That worked perfect! Now, do you know of a way (maybe in the Edit mask field) in the parameters to do an LTRIM function? I need to create either a dynamic parameter and have the user be able exclude "NONE" or do a static parameter using your instructions and do an LTRIM because some of the field values have spaces before the actual value. How does the "append all database values" option work? Not sure if it makes a difference but the field value will be different depending on the user.

 

[lbass]

You should just use the trim() function in the selection formula.

-LB

 

[jeffm777]

Thanks again! Worked like a charm.