When I run my report without any record selection filter, the report returns 14 records. However, when I enter these statements in the Records Selection Formula Editor the report only returns 10 records. Here is my record selection statement:
{Case.Type} = 'WC' and
if {?Employer} = "*" then
{EMPLOYER.EMPLOYERNAME} like {?Employer}
else
{EMPLOYER.EMPLOYERNAME} = {?Employer}
I query the case table and found that there were four cases that have not been assigned to any employer. Is there a way to capture the cases that have Null values in the employer column? Your help is greatly appreciated.
TIA
{Case.Type} = 'WC' and
if {?Employer} = "*" then
{EMPLOYER.EMPLOYERNAME} like {?Employer}
else
{EMPLOYER.EMPLOYERNAME} = {?Employer}
I query the case table and found that there were four cases that have not been assigned to any employer. Is there a way to capture the cases that have Null values in the employer column? Your help is greatly appreciated.
TIA