Skip to Content
0

​Pulling all records instead of parameters

May 20, 2017 at 03:30 PM

18

avatar image

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"

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers