Is it possible to program a report to change colors based on dates on printed report? Like anything after ten days it would print purple and anything after 30 days would print red. @color(element,tc,bc) seems to work with one color or the other but not both.
Am I missing something?
If (JobType = "Service") And (@ServerDate() >= (CallDate + 10)) { @Color(CallDate,5,15) @Color(jobtype,5,15) @Color(callnumber,5,15) @Color(telephoneno,5,15) @Color(companyname,5,15) @Color(service_req,5,15) } Else { @Color(CallDate,0,15) @Color(jobtype,0,15) @Color(callnumber,0,15) @Color(telephoneno,0,15) @Color(companyname,0,15) @Color(service_req,0,15) } If (JobType = "Service") And (@ServerDate() >= (CallDate + 30)) { @Color(CallDate,4,15) @Color(jobtype,4,15) @Color(callnumber,4,15) @Color(telephoneno,4,15) @Color(companyname,4,15) @Color(service_req,4,15) } Else { @Color(CallDate,0,15) @Color(jobtype,0,15) @Color(callnumber,0,15) @Color(telephoneno,0,15) @Color(companyname,0,15) @Color(service_req,0,15) }
Seems to only work on the later.
Thank you for any advice.
Flip
|