Joined: 31 Oct 2018
Location: United States
Online Status: Offline
Posts: 3
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?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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.
Joined: 31 Oct 2018
Location: United States
Online Status: Offline
Posts: 3
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.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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'
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