Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: how set different bg color for every second row Post Reply Post New Topic
Author Message
jorrebor
Newbie
Newbie


Joined: 12 Sep 2011
Location: Netherlands
Online Status: Offline
Posts: 18
Quote jorrebor Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.