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
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
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
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
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
Hi,
Then what is the alternative for this?
vsud
Dnt u have anycolumn having sequence of numbers?If u are having use that column
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