Skip to Content
avatar image
Former Member

​Pulling all records instead of parameters

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"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers