Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Create Group based on Details Post Reply Post New Topic
Author Message
jamboy40
Newbie
Newbie
Avatar

Joined: 31 Oct 2018
Location: United States
Online Status: Offline
Posts: 3
Quote jamboy40 Replybullet Topic: Create Group based on Details
    Posted: 01 Nov 2018 at 7:51am
I have an order that lists sold items. Some of these items require additional forms. I have a Y/N box already populated to note which items need the form. On my sales order, I created a group with a suppress for when the item is checked N. However, if there are Y items, it's still suppresses. I've narrowed it down, so if the first item is a Y, it prints the group saying "Need XXX Form", but if the first item is a N item, it suppresses. Even if item 2 is Y, it still does not print the Group area. It's like the Group will not look past the first line. What can I change to get the Group formula to look at all items to see if even one of them is checked as Y?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Nov 2018 at 2:28am
use a min/max value for the group on that Y/N field.
make sure there are no NULLS to be dealt with.
Then suppress based on the group group MIN or MAX result.
IP IP Logged
jamboy40
Newbie
Newbie
Avatar

Joined: 31 Oct 2018
Location: United States
Online Status: Offline
Posts: 3
Quote jamboy40 Replybullet Posted: 05 Nov 2018 at 4:07am
I'm sorry. Not sure I follow. It makes sense, I'm just not sure you to set that up. Do you have a quick example of the formula to set up a min max? The Y/N field I'm using is dot_flag. It would never be NULL.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Nov 2018 at 4:51am
insert a summary on the dot_flag field as a MAX for the group.
It should create a summary field in the group footer that will have a formula like
Maximum({table.dot_flag}, {table.groupfieldhere})

No you can use a suppression formula for the whole group as
Maximum({table.dot_flag}, {table.groupfieldhere})='N'
IP IP Logged
jamboy40
Newbie
Newbie
Avatar

Joined: 31 Oct 2018
Location: United States
Online Status: Offline
Posts: 3
Quote jamboy40 Replybullet Posted: 05 Nov 2018 at 12:00pm
That worked perfectly. Thanks so much for the guidance. Learned a new trick today.
IP IP Logged
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.016 seconds.