Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: IF isnull then maximum by order number Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Mar 2015 at 4:33am
test 2
place this formula on the detail section
 
maximum({MITTRA.MTTRDT},{OOHEAD.OACUOR})
 
what do you get?
IP IP Logged
ajp42
Newbie
Newbie


Joined: 26 Mar 2013
Online Status: Offline
Posts: 28
Quote ajp42 Replybullet Posted: 02 Mar 2015 at 4:37am
Doesn't work - comes back with error
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Mar 2015 at 4:38am
what error?
IP IP Logged
ajp42
Newbie
Newbie


Joined: 26 Mar 2013
Online Status: Offline
Posts: 28
Quote ajp42 Replybullet Posted: 02 Mar 2015 at 4:40am
there is an error in this formula - there must be a group that matches this field
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Mar 2015 at 4:42am
Insert a group using the OOHEAD.OACUOR field.
You cannot use a group condition on a summary (like maximum) unless the report has a group using that same field.
You can suppress the group header and footer if you want


Edited by DBlank - 02 Mar 2015 at 7:55am
IP IP Logged
ajp42
Newbie
Newbie


Joined: 26 Mar 2013
Online Status: Offline
Posts: 28
Quote ajp42 Replybullet Posted: 02 Mar 2015 at 4:46am
Just tried that - inserted group and then re did and the same message came up - there must be a group that matches the field
IP IP Logged
adavis
Senior Member
Senior Member


Joined: 30 Oct 2012
Online Status: Offline
Posts: 104
Quote adavis Replybullet Posted: 02 Mar 2015 at 5:25am
double check that your formula is written with the correct syntax

maximum({MITTRA.MTTRDT},{OOHEAD.OACUOR})

And that you created a group using the OOHEAD.OACUOR field

For some reason, CR isn't recognizing this group, so it is likely one of those two errors.
IP IP Logged
ajp42
Newbie
Newbie


Joined: 26 Mar 2013
Online Status: Offline
Posts: 28
Quote ajp42 Replybullet Posted: 02 Mar 2015 at 6:03am
this hasn't anything to do with me using Crystal reports XI version
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Mar 2015 at 8:02am
XI should be a moot in this discussion.
try using the User Interface (UI) to create your group summary.
You already have a group (just one?) using the OACUOR field.
click on the Sigma button (Blue E)
Insert Summary box opened up
select MITTRA.MTTRDT as the field to summarize
select Maximum as the calculate this summary option
select group #1 OOHEAD.OACUOR  as your sumamry location
select OK
 
this should drop the max into your group footer.
does this work and display the correct value for your group?
IP IP Logged
ajp42
Newbie
Newbie


Joined: 26 Mar 2013
Online Status: Offline
Posts: 28
Quote ajp42 Replybullet Posted: 03 Mar 2015 at 12:40am
thanks for this - I have sorted it by max in summary like you say
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.031 seconds.