Can I Highlight a view

[syncdba]

Hi ,
I'm using a view in my report.
select id,accountid,
case when "ISP_Complete_Account_Plan__c"='true' then 'Complete_Account_Plan : COMPLETED'
else 'Complete_Account_Plan ' '
end as Complete_Account_Plan,
case when "ISP_Identify_Potential_Opportunities__c"='true'
then 'ISP_Identify_Potential_Opportunities : COMPLETED' else 'ISP_Identify_Potential_Opportunities ' '
end as ISP_Identify_Potential_Opportunities ...so on...

I need to Highlight the columns when it is "COMPLETED".
I know I can do with Fields.

 

[synapsevampire]

So you'd highlight an entire column of data if any of them are completed?

Crystal doesn't have columns, it has fields and rows (details section).

So you can highlight the row if one or all have completed (still need to check for all of them), or you can highlight each field individually.

It doesn't work like Excel, it works like a database.

Perhaps you can shed some light on this by providing some technical informaiton:

Crystal version
Database used
Example dtaa
Expected output

Works better than trying to describe requirements.

If you intend to hightlight each row, then you might even set another field in the View that demonstrates whether any of the fields are to be highlighted.

So the standard would be to use the color for either the row or a field and have a formula which evaluates when it is to be highlighted:

if {table.field} like "*" & "COMPLETED" + "*" then
cryellow
else
crwhite

-k