chiplarsen
IS-IT--Management
Hello, I am having trouble color coding the column headers on my Crosstab report. I want certain doctors to be highlighted in various colors. I am using the following formula:
This formula works everywhere else except in the column header of the crosstab. The way that I am placing this formula is by right clicking the column header box and selecting "Borders and Colors". I then go to the "Color" section and click the "x+2" button. After placing the formula there, it checks out with no errors. Has anyone else seen this problem?
Code:
if {casepro.primpract_res_id}=229
then crRed
else
if {casepro.primpract_res_id}=287
then crBlue
else
if {casepro.primpract_res_id}=124
then crYellow
else crWhite
This formula works everywhere else except in the column header of the crosstab. The way that I am placing this formula is by right clicking the column header box and selecting "Borders and Colors". I then go to the "Color" section and click the "x+2" button. After placing the formula there, it checks out with no errors. Has anyone else seen this problem?