Crystal Reports how set different bg color for every second row

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: how set different bg color for every second row

Post Reply

Post New Topic

Author	Message
jorrebor Newbie Joined: 12 Sep 2011 Location: Netherlands Online Status: Offline Posts: 18	Topic: how set different bg color for every second row Posted: 20 Oct 2011 at 1:24am
	Hi all i want to display every other row in my report with a different color. I normally do this by: if 2 mod recordNumber = 1 then crRed else crWhite. But in this report i supress printing of some records so the order of odd and even recordnumbers becomes arbitrary. Is there something like printRecord variable? thanks Jorrit
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Oct 2011 at 3:53am
	i use a Running Total in place of the recordnumber. In the running total I use a conditional evaluation formula to count records that ar not suppressed (inverse of the suppression formula) If you are grouping you can also reset the value on the change of a group. variable formulas would also do the same thing. Edited by DBlank - 20 Oct 2011 at 3:55am
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum