Skip to Content
author's profile photo Former Member
Former Member

changing the color of a row in Crosstab of crystal report

I have designed crystal report which contains a Crosstab in it and works fine. one of the fields is Time. I want to the whole row color font be changed for the Max Hour which I pass to the report . I can change just the color of the MaxHour Cell but the whole Row. like the following:

the Code is :

if(CurrentFieldValue={?MaxHour}) then

crteal
else

crmaroon

I have set it when I right click of the Time filed, format Object, and then Font. what should I do for changing the color of the whole row of Max Time?

Thank you

crosstab.jpg (177.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 06, 2017 at 09:06 AM

    Hi Nooshin,

    Right-click one of the summary cells > Format field > Font tab > Click the formula button beside Color and use this code:

    if GridLabelAt("Row Field", CurrentRowIndex) = {?MaxHour} then crTeal else crMaroon

    Replace "Row Field" with the field you've used as the Crosstab Row. The field should be enclosed in double-quotes like the way I have above.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.