Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting font in crosstab

Status
Not open for further replies.

stussy

MIS
May 22, 2003
269
GB
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
 
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
 
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...
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top