Conditional formatting of crosstab CRXI 1

[LT2]

Using CRXI w/SQL 2000

I've got a cross tab with the following Rows:

Command.Payor,
Command.TxDesc,
Command.Paid_As

with a summarized field for Command.Payor_Amount

I would like to highlight bold and in red any Command.Paid_As that is not like '%ABW%' or '%Adult%' and likewise the Command.Payor_Amount following the same criteria.

How can I accomplish this?

My attempts have been futile.
~LT

 

[lbass]

Do mean the "%" as wild cards? In the body of the report you would use "*"--"%" is used within commands or SQL expressions only.

Right click on both the row label and the the summaries you want bolded->format field->font->style->x+2 and enter:

if not(gridrowcolumnvalue("Command.Paid_As") like ["*ABW*","*Adult*"]) then
crBold else
crRegular

-LB

 

[LT2]

Yes I did mean "%" as wild card. Your solution works great. Your the Best! Thanks ~LT