Highlighting cross tabs

[johnjrd]

Is the following possible

I have a cross tab that shows a register for a class

Date 1 Date 2 Date 3
Name register register register
mark mark mark

Name register register register
mark mark mark

I then have a another date field that tells me when some one left.
I want to highlight the register mark to tell me that the learner as left on this date.

Ive tried to use the GridRowcolumnvalue to control the background colour.

So i have a formula like this

if GridRowColumnValue ("sesion_date") >= {leftdate} then
crLime
else
crWhite

This seems to highlight all the cross tab using the first left date to test against, is there a way of applying this to each line of the cross tab and evaluate the dates individually.

Thanks

 

[Madawc]

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference. I don't think any version of Crystal allows it in a Crosstab, which Crystal builds itself.

You could control the colours in a Mock-Crosstab, if you think it's worth it. A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[johnjrd]

Thanks

Sorry am using Crystal 11.5

Anyway instead of highlighting i am changing the actual register mark depending on a set of rules, it doesnt look as good but at least the register can now be seen and it tells me when a learner as left etc.

Would be good if you could do conditional formatting on a crosstab
that did not affect all of the cross tab just when certain values changed.