Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Summing Issue Post Reply Post New Topic
<< Prev Page  of 5 Next >>
Author Message
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 25 Nov 2013 at 10:24am
I have been able to talk with the requester and they have decided that it is okay to only show the "late" line of the po.
 
I have figured out how to suppress the "on-time" lines using the section expert. So far so good....
 
Now the issue is that I want to suppress the po # for any po's that are showing as "on-time". the formula I'm using to suppress in the section expert is:     @late_line = "on_time"
 
For example:
 
po#             desired rcvd date           act recvd date           late/on-time
32165
 
line 1               5-15-13                                5-14-13              on-time
line 2               5-15-13                                 5-16-13              late
 
 
I hope this is enough info to make sense of what I am trying to do. Thanks!
 
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 25 Nov 2013 at 10:40am
just use the same formula it should work.
IP IP Logged
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 26 Nov 2013 at 2:27am
Actually I tried that but what is happening is that it is suppressing the example above po#. I wonder if it's because the 1st line of the po is "on_time". so it'll show just line 2 but no po# and no line 1. THe missing line 1 is ok (I cleared it with the requester) but I need the po # to show for this type of situation. Any ideas on how to make this work?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Nov 2013 at 4:02am
I am guessing you mean to suppress an entire PO group where everyline is 'on time'?
you can use a group condition with a min or max...
minimum(@late_line,table.po) <> "late"
 
Is that what you are looking for?
IP IP Logged
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 26 Nov 2013 at 5:15am
hmm didn't think of that. let me try it. thank you!
IP IP Logged
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 26 Nov 2013 at 5:44am
I tried it. It's telling me that @late_line can't be summarized. And yes I am trying to suppress an entire group where every line is "on_time".
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 26 Nov 2013 at 6:12am
what formula you use to display late/on-time field?
IP IP Logged
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 26 Nov 2013 at 6:16am
if Minimum ({RECEIVER.RECEIVED_DATE}, {PURC_ORDER_LINE.LINE_NO})>{PURCHASE_ORDER.DESIRED_RECV_DATE} then "late" else "on_time"
 
 
this is my late line formula
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 26 Nov 2013 at 6:49am
if you rewrite this formula as
{RECEIVER.RECEIVED_DATE}>{PURCHASE_ORDER.DESIRED_RECV_DATE} then "late" else "on_time"
Dblank's solution will work, but i'm not sure if this will bring correct results.
IP IP Logged
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 26 Nov 2013 at 7:54am

Would I put this in the section expert or the po field itself?

IP IP Logged
<< Prev Page  of 5 Next >>
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.012 seconds.