If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Altenate Row Colors Problem

Started by vsudaya, 02 Jul 2006 04:37:30 AM

Previous topic - Next topic

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