Altenate Row Colors Problem

[vsudaya]

Hi all,

I am implementing alternate row colors in a report using conditional style, its working fine. i am doing dynamic sorting on a particular coloumn(asc,desc). the code is given below. but whenever sales voume number is continuosly same when i ascend or descend. the alternate row color is not working, its pading with same color, i tried with rank function also. how to over come this issue.

mod(running-count(sales_volume),2)


any thoughts?

Thanks in advance
vsud

[JGirl]

Try using mod(running-total(1 for report),2) and applying your conditional fomatting on this.  This should always increment the total by 1 for each record.

J

[vsudaya]

Hi,

Its not giving the number sequence continuos, the problem i am using dynamic sorting. If i take it for report, the sequence is not coming to set the mod function.

thanks in advance
vsud

[mrcool]

Hi...that function works fine on only columns having contineous r number sequence like primary key column....if the value repeats in the column u wont get alternate colors

[mrcool]

Hi...that function works fine on only columns having contineous r number sequence like primary key column....if the value repeats in the column u wont get alternate colors

[vsudaya]

Hi,

Then what is the alternative for this?

vsud

[mrcool]

Dnt u have anycolumn having sequence of numbers?If u are having use that column

[vsudaya]

Hi all,

this function working for me mod(running-total(1 for report),2) , but when do ascending on sales_volume(dynamically) from report viewer, the running-total sequence is not coming perfectly when we have same value like '0'. it is missing the seuqnce after 1,2,3,11,4,5,6,7,8 etc its giving.

thanks in advance
vsud