Click to See Complete Forum and Search --> : HEAT/CRYSTAL Problems


Powell123
October 12th, 2005, 12:15 PM
I have written the following code into Crystal Record Selection it is based on some parameter selctions that begin with ? ie.?Detail. I want to be able to search using two parameters on the same table. These parameters are
?Detail(Non Sims) and ?Detail(SIMS). When i run the report however with my code listed below it only returns results from the ?Detail(SIMS) parameter and ignores any requests from the ?Detail NonSims. Can anyone help me out with why this is. Both parameters work fine on their own it is just if i introduce them together that one over rides the other.

Please find code below - many thanks

{Profile.SCHOOLNAME} <> "DUMMY SCHOOL ENTRY FOR MULTIPLE FAILURES" and
cdate({CallLog.RecvdDate}) IN {?Start} TO {?End} and
{CallLog.CallStatus} = {?Call Status} and

(IF {?Call Type}= "ALL"
THEN {CallLog.CallType}[1] IN ["A" TO "Z"]
ELSE {CallLog.CallType} = {?Call Type})

AND

(IF {?Detail (NON SIMS)}= "ALL"
THEN {Detail.Descriptio}[1] IN ["A" TO "Z"]
OR {Detail.Descriptio}[1] IN ["a" TO "z"]
OR {Detail.Descriptio}[1] IN ["1" TO "9"]
ELSE {Detail.Descriptio} = {?Detail (NON SIMS)})


AND


(IF {?Detail (SIMS)}= "ALL"
THEN {Detail.Descriptio}[1] IN ["SIMS*"]
ELSE {Detail.Descriptio} = {?Detail (SIMS)})

AND





(IF {?Priority}= "ALL"
THEN{CallLog.Priority}[1] IN ["1" TO "9"]
ELSE {CallLog.Priority} = {?Priority})


AND

(IF {?School Phase}= "ALL"
THEN {Profile.SCHOOLCAT}[1] IN ["A" TO "Z"]
OR {Profile.SCHOOLCAT}[1] IN ["a" TO "z"]
OR {Profile.SCHOOLCAT}[1] IN ["1" TO "9"]
ELSE {Profile.SCHOOLCAT} = {?School Phase})