Highlight cross-tab of True displays

[LT2]

Hello,

Using CRXI w/SQL Svr.

I've got a cross-tab using the following:

[ol]Rows:
[li]@Over50 = ({Command.Age})>50[/li]
[li]@Co-Occurring = {Command.MH}= 'Yes'[/li]
[li]CommandPrimSA[/li]
[/ol]
[ol]Summarized Fields:
[li]DistinctCount of Command.ClientID[/li]
[/ol]

I only have 1 highlight using the Highlight Expert, the first row: Value ofOver 50 is equal to True. What I would expect is for only row#1 resulting in True to be highlighted.

But what is highlighted is Row#1 = True, Row#2 = True and where both are true, the PrimSA is highlighted along with the Totals for these. No other true for Row#2 is highlighted where Row#1 is false.

This is exactly what I want and was under the impression there wasn't a way to do this. Of course I want to replicate this for same style of cross-tabs with different formulas of the same style, yet when I just put the highlight requirements in Row#1 I don't get the same results. Why not?

So I copied the cross-tab highlighted the way I want to another report footer and as soon as I begin to change the rows to replace @Over 50 with @Adults, I immediately get a CRW32 error where VB wants to debug. Answering yes gets me no where and answering no shuts down Crystal Reports and all items I had open.

1)How do I get the cross tabs to highlight exactly what I want?

2)Why do I keep getting the crw32 error? CR Pro Full, v11.0.0.2178 is installed on a Toshiba Mobile Intel Pentium 4 - M CPU 2.00GHz, 1.99GHz, 1Gb of RAM laptop using MS XP Pro Sp3. My investigation thus far has led me to others experiencing this type of error for various reasons and the acknowledgement that over time Crystal software becomes corrupt and requires a re-install. Has anyone else experienced and remedied this problem?

LT

 

[LT2]

1)In addition to the above I also tried the following:
[li]Verified no Highlight Expert formulas exist.[/li]
[li]Clicked on all the fields I want highlighted (@Adults, @Co-Occurring, PrimSA, the counts and totals) and placed the following formula under formatting font color:

if gridrowcolumnvalue ('@Adults') = true
and gridrowcolumnvalue ('@Co-Occurring') = true
then crBlue
else defaultattribute

[/li]

All highlighted blue except @Adult (row#1). Any idea why?

LT

 

[lbass]

What values appear in the row labels for Row#1? I'm assuming you mean the first instance of the crosstab row#1 is not blue.

-LB

 

[LT2]

Yes this is correct. The value for the first row = 'True'.
I was really expecting that the font would be blue.

I cheated by following up with the Highlight Expert to make it so, but I would like to understand why it didn't change. It was one of many fields I grabbed to format together.

LT