CODEWITHSUNDEEP
crystal-reports
Chuck-Kim Davis
Chuck-Kim Davis

Reputation: 1

Crystal Report , Cross tabs and conditional formatting

I am using a formula in my Crystal cross tab and cannot conditional format that field. Is there a way to do that? If I use Highlight expert I would have to add are variables.. I have a flag Y or N if the metrics is in range and I want all out of range to be red but that field (formula) does not show up in my list to pick from. If I write a formulas under font color like If {RC_Agent_ReportCard_sp;1.Within_Goal} = 'N' then crRed else crBlack everything turn red ... Help

If I write a formulas under font color like If {RC_Agent_ReportCard_sp;1.Within_Goal} = 'N' then crRed else crBlack everything turn red ... Help

If I write a formulas under font color like If {RC_Agent_ReportCard_sp;1.Within_Goal} = 'N' then crRed else crBlack everything turn red ... Help

Upvotes: 0

Views: 871

Answers (1)

Pawan Gupta
Pawan Gupta

Reputation: 187

You have to use GridRowColumnValue in your formula. Because this will give you the current value of the cell in the cross tab grid. So the condition will be some thing like this:

 If GridRowColumnValue({RC_Agent_ReportCard_sp;1.Within_Goal}) = 'N'
 then crRed else crBlack

Thank you.

Upvotes: 1

Related Questions