This works Correctly. I would like to add a second parameter the only pulls if the jobid matches the record.
if {?Customer} = "ALL" then true else {Job1.Cust-ID-Bill-to} = {?Customer} and
if {?JobID} = "ALL" then true else {Job1.Job-ID} = {?JobID} and
{?JobID}={JobComments1.Job-ID} and
{Job1.System-ID} = "1"
This pulls all records when I add the second all line
if {?Customer} = "ALL" then true else {Job1.Cust-ID-Bill-to} = {?Customer} and
if {?JobID} = "ALL" then true else {Job1.Job-ID} = {?JobID} and
{JobComments1.Description} like "*" + {?Job Note} + "*" and
{?JobID}={JobComments1.Job-ID} and
{Job1.System-ID} = "1"