Parameters To Include Null Or Empty String Values

[Adam_Alsop]

I have a table that has both Nulls & Empty Strings that I want to use as a Dynamic Parameter. Even though there is an indication of the Null/Empty String value when the parameter prompt comes up, selecting the value of Null/Empty String results in no records being returned. I have a formula to display the values in the report (where I substitute "Unknown" for the Null/Empty String values), but I am not able to do a parameter on that formula.

I guess in general, this is a situation of needing to be able to use a Dynamic Parameter based on a formula field.

Thanks for any assistance!

Edited by: Dragon77 on Apr 2, 2010 9:39 AM

[Former Member]

here is an idea, maybe it will work.

Add an entry to your dynamic parameter for 'Unknown'

in your selection formula, you could do something like

if {?Param} = 'Unknown'

then isnull(field) or field = ''

else field = {?Param}

[Adam_Alsop]

When I try to add the "Unknown" value to the Dynamic Parameter (which is based on the values of a field), it will not allow me to enter the value, it only wants to select by another field.