Joined: 26 Oct 2017
Online Status: Offline
Posts: 1
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!
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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.
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
IP Logged
