Hi,
Can anyone help me using an instring formula combined with Not Has value please? I have the list of Parameter's formulae here. I would like to give wildcard characters for C or leave it without supplying any parameters so that it runs for all C values.Please help

(not HasValue({?A}) OR {table.A} = {?A}) and
(not HasValue({?B}) OR {table.B} = {?B}) and
(not HasValue({?C}) OR instr({table.C},{?C})>0) and
(not HasValue({?D}) OR {table.D} = {?D}) and
(not HasValue({?E}) OR {table.E} = {?E})

Thanks

Thanks for the response Ryan.. But this doesnt work.. I am getting this error "This array may be Subscripted For Example Array"