HuseyinEce
Programmer
Hi,
Please look at the attached sample crosstab report. The report shows each job's status in a month(1,2,3,4.. is days of the month.)
I am trying to change days'(1,2,3,4...) background color based on my one of my field value(field is bd). This field keeps value that shows that day business day or not. If it is weekend then my value is “N” other wise is “Y”.
I am trying to do this under format field editor --> Border-->Background-->X2.
I have used below code but it doesn’t work.
“if {S_CCO_JOB_STATUS;1.bd} = "Y" then crGreen else crNoColor “
Here is the attached file link:
Can anyone please help me how to do that?
Any help is greatly appreciated,
Thanks
Please look at the attached sample crosstab report. The report shows each job's status in a month(1,2,3,4.. is days of the month.)
I am trying to change days'(1,2,3,4...) background color based on my one of my field value(field is bd). This field keeps value that shows that day business day or not. If it is weekend then my value is “N” other wise is “Y”.
I am trying to do this under format field editor --> Border-->Background-->X2.
I have used below code but it doesn’t work.
“if {S_CCO_JOB_STATUS;1.bd} = "Y" then crGreen else crNoColor “
Here is the attached file link:
Can anyone please help me how to do that?
Any help is greatly appreciated,
Thanks