(({Placements.name} in {?Company Name} or isnull ({?Company Name})) or
({Placements.customer} in {?Customer Id} or isnull ({?Customer Id}))) and
{Placements.cob} in {?COB}
Above is what I have in my record selection, I am needing to prompt for company, customer and cob, cob must ALWAYS have something but if company is selected customer can be null or vice versa, I can not get this to work. Any help would be appreciated.
({Placements.customer} in {?Customer Id} or isnull ({?Customer Id}))) and
{Placements.cob} in {?COB}
Above is what I have in my record selection, I am needing to prompt for company, customer and cob, cob must ALWAYS have something but if company is selected customer can be null or vice versa, I can not get this to work. Any help would be appreciated.