Highlighting A Group... 1

[ChiTownDiva]

Happy Thursday All....(-:

I've got a weird question...

I've got a report where the details of the report ARE the group headers.

For instance: The details which we'll call "local codes" are "E3FF000", "E3FF030",etc. The group header is a formula (called "company&quot from the local code--"Left ({local code}, 2)". The details are suppressed because all I care about is the "E3" part of the "local code".

What I want to do is highlight those records that fall into a particular category, i.e., "If {Local Code} like "E3*" then make it silver (or "If {@company} = "E3" then make it silver).

I think in order to do this I need to create a counter in the details, but I'm not sure. Nothing I'm trying is working.

Any thoughts?

Thanks in advance.

ChiTownDivaus

 

[Naith]

Hey ChiTownDivaus,

I shouldn't think you need a counter for this, because it doesn't sound like you're trying to create a pattern of action.

You've touched on the appropriate logic in your penultimate paragraph.

Go into the Color tab of Format section, and enter:

If (Left({Local Code},2) = "E3"
or {@company} = "E3&quot
Then CRSilver
Else CRNoColor;

All the best,

Naith

 

[ChiTownDiva]

Thanks Naith...I knew I probably made it harder than what it was.

Thanks again!

ChiTownDivaus