Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Highlight Alternate Rows Issue Post Reply Post New Topic
Author Message
JamesKay
Newbie
Newbie


Joined: 26 Oct 2017
Online Status: Offline
Posts: 1
Quote JamesKay Replybullet Topic: Highlight Alternate Rows Issue
    Posted: 30 Oct 2017 at 9:56am
Hi,

(if RecordNumber mod 2 = 0 then crSilver else crNoColorwell )

Using this formula worked well in one report of mine but in another report its colors all the rows.
The only difference is in the report that it is not working has another formula present to suppress duplicates in the detail section.
{Origins.Time}=previous ({Origins.Time})
When I delete this formula the alternate color works but I have unwanted duplicates.
Is there an easy way around this ?
Thanks!


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Oct 2017 at 4:36am
Swap out RecordNumber with a Running Total. The RT should be a count that uses the same criteria expression to exclude those rows from the count.
For duplicates it sometimes can be as easy as doing an distinct count.
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.016 seconds.