Formatting font in crosstab

[stussy]

Hi

I have a crosstab report that works fine (a rarity!) apart from one thing - I can't get condtional formatting to work. This is the formula I am using:

if {Staff.Manager Privileges} = true then crred else crblack

I get 'No errors found' when checking, but all the text stays black no matter what. I have applied the formula to all fields on the crosstab (20 fields, 2 columns of 10 running 'nth smallest')

Any ideas?

Cheers

Mike

 

[lbass]

Is {Staff.Manager Privileges} either a row or column field? I think you will have to make it one and then use formulas like:

if gridrowcolumnvalue("Staff.Manager Privileges") = true then crRed else crBlack//for summary cells

if currentfieldvalue = true then crRed else crBlack //for label

For a second row (or column label), I think you might have to hardcode it as in:

if currentfieldvalue = "2" then crRed else crBlack //e.g., for an ID field as row

-LB

 

[stussy]

Thanks for that, but no joy - once I make staff.manager privileges a row or column, it blows the entire report structure out of the window. Even hiding/suppressing the field leaves it looking awful, and what fitted neatly onto A4 portrait winds up running across 4 pages.

I think it was you who got the thing looking so great in the first place lbass, so I'm loath to muck it up for the sake of a little highlighting...

 

[lbass]

You might try using the A icon to reduce the font of the {staff.managerprivileges} row label and summary to 1 pt. Then you can drag the boundaries to make them very narrow. By the way, the placement of the field as a row or column depends upon whether you want to be able to highlight the row or column.

-LB