Skip to Content
0
Former Member
May 20, 2017 at 03:30 PM

​Pulling all records instead of parameters

42 Views Last edit May 04, 2018 at 12:00 PM 2 rev

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"