Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Crstal Report alternate color Help? Post Reply Post New Topic
<< Prev Page  of 2
Author Message
skailey
Newbie
Newbie


Joined: 13 Jul 2009
Location: United States
Online Status: Offline
Posts: 13
Quote skailey Replybullet Posted: 28 Sep 2009 at 12:13pm
Thanks DBlank.  It still does not seem to be working properly.  Here is what I have, maybe a second pair of eyes can see what I am missing.
 
My suppression formula for records in the detail section is:
 
({view.DaysCount1}) < (({view.DaysCount1Standard}) + 30)
AND ({view.DaysCount2}) < (({view.DaysCount2Standard}) + 30)
AND (({view.DaysCount3}) < (({view.DaysCount3Standard}) + 30) OR {view.marker3} = "")
AND ({view.DaysCount4}) < (({view.DaysCount4Standard}) + 30)
 
So, per your suggestion... the first part of the formula to show the row is:
 
({view.DaysCount1}) >= (({view.DaysCount1Standard}) + 30)
AND ({view.DaysCount2}) >= (({view.DaysCount2Standard}) + 30)
AND (({view.DaysCount3}) >= (({view.DaysCount3Standard}) + 30) AND {view.marker3} <> "")
AND ({view.DaysCount4}) >= (({view.DaysCount4Standard}) + 30)
 
and the change of field is:
 
Next (view.ABCfield) <> ABCfield
 
My bgcolor on the detail section is still coded as mentioned above in your post from July. 
 
On the report, it looks pretty random.
 
Record A
Record A
Record A
Record B
Record B
Record C
 
IP IP Logged
Pink
Newbie
Newbie


Joined: 25 Sep 2009
Online Status: Offline
Posts: 10
Quote Pink Replybullet Posted: 28 Sep 2009 at 12:20pm
I'm not sure to understand exactly your problem, but here is how I do it :

WhilePrintingRecords;
if RecordNumber mod 2 = 0 then
crSilver
else
crWhite

Never had bad feed back from client about it....

Pink
IP IP Logged
skailey
Newbie
Newbie


Joined: 13 Jul 2009
Location: United States
Online Status: Offline
Posts: 13
Quote skailey Replybullet Posted: 28 Sep 2009 at 12:22pm
Yeah, that is how I have been doing it Pink.  It is something with the counter that is the issue, not the piece that you mentioned.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2009 at 12:30pm
Sorry. Trying to think this through...
You just have to adjust your RT formula to include / exclude the records that you want so your counter works correctly.
Try:
NOT(
({view.DaysCount1}) < (({view.DaysCount1Standard}) + 30)
AND ({view.DaysCount2}) < (({view.DaysCount2Standard}) + 30)
AND (({view.DaysCount3}) < (({view.DaysCount3Standard}) + 30) OR {view.marker3} = "")
AND ({view.DaysCount4}) < (({view.DaysCount4Standard}) + 30)
)
AND
Previous(abcfield)<>abcfield
IP IP Logged
skailey
Newbie
Newbie


Joined: 13 Jul 2009
Location: United States
Online Status: Offline
Posts: 13
Quote skailey Replybullet Posted: 28 Sep 2009 at 12:39pm
DBlank,
 
That worked, as well as the previous version.  I was putting the second part of the formula in the "Reset" formula section of the Running Total Counter instead of putting it in with the records I wanted to look at.  Once I changed that back to "Never" and added the Previous(ABCField) <> ABCField to the RT formula, it worked great.
 
Thanks for all of your help.  These forums are a life saver.


Edited by skailey - 28 Sep 2009 at 12:40pm
IP IP Logged
Pink
Newbie
Newbie


Joined: 25 Sep 2009
Online Status: Offline
Posts: 10
Quote Pink Replybullet Posted: 28 Sep 2009 at 1:19pm
I dont understand why you need a counter....

I had the same result(looked like random) as you mentionned when I first tried to do alternate row color. I found that default is "WhileReadingRecords" thats why I added "WhilePrintingRecords;" and all my problems where solved since supressed row are not printed...

Anyway, as someone "important" said one day : "All roads lead to Rome"...lolll


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2009 at 1:26pm

The original need had to do with highlighting like rows so it was not a straight alternate row highlighting.

record A
record A
record A
record B
record C
record C
record D
record D
record D

 



Edited by DBlank - 28 Sep 2009 at 1:26pm
IP IP Logged
skailey
Newbie
Newbie


Joined: 13 Jul 2009
Location: United States
Online Status: Offline
Posts: 13
Quote skailey Replybullet Posted: 28 Sep 2009 at 1:29pm
That is correct.  Record A would have 3 detail lines (2 suppressed) and I wanted each record to be an alternate color.
IP IP Logged
<< Prev Page  of 2
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.015 seconds.