how can i display same colour for same records in a column alternatively???

[Former Member]

i have one column named as empID,which contains nuumber of same i.e repeated records,i want to display same record field with the same colour,and other with the alternate colour,

so how do i get my solution..???

[abhilash_kumar · Accepted solution]

Hi Amol,

Here's what you need to do:

1) Go to the Section Expert > Select the details section > Click the formula button beside 'Background Color' and use this code:

if OnFirstRecord then

numbervar x := 1

else

(

    if {Emp_ID} <> Previous({Emp_ID}) then

        x := iif(x=1,0,1);

);

if x = 1 then crGray else crYellow

-Abhilash

[Former Member · Accepted solution]

Thanx Abhilash,

it really works.

[Former Member]

Hi,

See these: http://scn.sap.com/thread/3666693

How to get alternating background colour for records in Crystal Reports - Stack Overflow

--dj