Formatting a cross tab column 3

[sk8er1]

I would like to format the column value of a cross tab.
It will be in a date range...if the column value happens to be the current date value, I would like to color the column with a different color....How is this accomplished....

Thanks so much.

 

[lbass]

Right click on a cell within the grid->change border->background->x+2 and enter:

if GridRowColumnValue ("table.date") = currentdate then crYellow else crNoColor

Within the quotes, place the database field, but remove the curly brackets. Or, go to the customize style tab, highlight the column field and check "Alias for Formulas" to see what should be entered within the quotes.

-LB

 

[sk8er1]

I can't seem to find the change border->background->
spot. I am using the crystal that comes with Visual Studio.
There is a highlighting expert... Thanks for the help.

 

[lbass]

Not sure what's available in Visual Studio. If you right click on the upper left hand corner of the crosstab, do you see "Border and Colors"? This would take you to the screen with "background".

I don't think you can use the highlighting expert for this, since you want to highlight all values depending on the column label, not on the value itself.

-LB

 

[sk8er1]

I'll keep looking, but I dont see borders and colors yet

 

[sk8er1]

Where can I use the CurrentFieldValue and GridRowColumnValue functions in a cross tab to format for a specific situation.

 

[lbass]

Did you find the screen where you can format background color for the crosstab cells? Where do you see "CurrentFieldValue" and "GridRowColumnValue"? The problem is that most of us probably don't know what is available to you in Visual Studio. Is there a "format" tab? If so, what options do you have?

-LB