Highlight Alternate Rows Issue
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22491
Printed Date: 30 Apr 2024 at 2:29am
Topic: Highlight Alternate Rows Issue
Posted By: JamesKay
Subject: Highlight Alternate Rows Issue
Date 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!
|
Replies:
Posted By: DBlank
Date 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.
|
|