Change Column BAckGround

[198311]

hello,
How Can I change column's background when name of this column is work ??

bye,

 

[198311]

and where put in this formula ??

 

[MisterMo]

I don't think there is such thing as column Background, beside columns are kind of static in a report unless you are using Cross Tabs.
You could add a box which could be placed from the header of your work column and cross over the detail section of the same column, right click format the box to be filled with the colour of your choice.
If this does apply, could you post some more infos regarding your report, also version of CR and Database


-Mo

 

[198311]

hello,

I have CR 10 and this is a CrossTab

bye

 

[MisterMo]

One option is to right clik on both the header and value fields and add a formula on the format fields>border background color

if {table.field}<>'Work' then
blue
else
crnocolor

then right click crosstab expert and customize style

uncheck the show cell margin, this will give the impression of a column coloured


-Mo

 

[lbass]

In a crosstab, you would need to right click on an inner cell->format field->border->color->background->x+2 and enter:

if gridrowcolumnvalue("table.colfield") = "Work" then
crYellow else crNocolor

Substitute your column field for "table.colfield" and replace the curly brackets with double quotes.

-LB

 

[MisterMo]

Or you can use the Highlighting Expert to do it for you by right click onthe desired cell and add the formula there


-Mo