Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Group Footer will not suppress Post Reply Post New Topic
Page  of 2 Next >>
Author Message
chudok
Groupie
Groupie


Joined: 18 May 2010
Online Status: Offline
Posts: 70
Quote chudok Replybullet Topic: Group Footer will not suppress
    Posted: 31 Jan 2020 at 5:35am
I have a form that has parameters to hide the whole page if these parameters are meet. For some reason it still shows a group footer.Only the group footer. I have even put in suppression code at the group footer level. Any ideas what would cause this not to hide like the rest of the page does.    The data in the group footer is text only.

Edited by chudok - 31 Jan 2020 at 5:35am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Jan 2020 at 7:35am
Is it every group instance or just a specific group? any NULL values? What is the suppression criteria?
IP IP Logged
chudok
Groupie
Groupie


Joined: 18 May 2010
Online Status: Offline
Posts: 70
Quote chudok Replybullet Posted: 31 Jan 2020 at 10:08am
It is one specific group. there is not any null values. in the report parameters I am asking for only specific data to show, but the data i do not want to show is showing the text info on the group discussed. I want the report parameters to take priority and if i ask for it not to show in the report don't bring in the group footer. Let me know if there is somewhere i can even send you a copy of this report.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Jan 2020 at 10:32am
then your suppression logic is incorrect for the actual logic you want to use. If you are using a field level suppression criteria like table.field='A' and using that for group a group footer it is executing based on the last row in the group. Instead your logic should be about all the rows in the group or if any of the rows has the condition you are checking against.
IP IP Logged
chudok
Groupie
Groupie


Joined: 18 May 2010
Online Status: Offline
Posts: 70
Quote chudok Replybullet Posted: 03 Feb 2020 at 8:12am
So I several different groups. these are based on division, customers, Sales Orders. then I am trying to have some data show only for a specific customer on the bottom of the page. it shows for all customer that i not want this to even print for. So I have a bunch of orders with blank header and details but has this footer that i do not want.   Please advise if there is anther way that i can show you what this looks like.   
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2020 at 8:33am
what is your suppression criteria (formula)?
IP IP Logged
chudok
Groupie
Groupie


Joined: 18 May 2010
Online Status: Offline
Posts: 70
Quote chudok Replybullet Posted: 04 Feb 2020 at 1:49am
Not({SO_PickingSheetWrk.CustomerNo}like "HDCOM")

not like a certain customer.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 Feb 2020 at 2:21am
So do you want to suppress a group when they have that customer in the group (I assume associated to the sale order)? Your suppression is a row evaluation so it is going to suppress the group footer only if the last row in that group meets the condition. What do you really want it to do? Suppress if all the customers in that group are HDCOM? Something else?

Edited by DBlank - 04 Feb 2020 at 2:21am
IP IP Logged
chudok
Groupie
Groupie


Joined: 18 May 2010
Online Status: Offline
Posts: 70
Quote chudok Replybullet Posted: 04 Feb 2020 at 2:26am
Suppress footer for all customers in that group that are NOT "HDCOM"
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 Feb 2020 at 3:03am
Sorry, confused. A group is multiple rows and only applies once to the entire group so how can you suppress a footer for per customer inside a group? You described your grouping as "division, customers, Sales Orders" and I interpret this as group one =division, group two customer and group 3 Sales order. Which of the 3 group footers are you trying to suppress?
IP IP Logged
Page  of 2 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.016 seconds.