Joined: 18 May 2010
Online Status: Offline
Posts: 70
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.
Joined: 18 May 2010
Online Status: Offline
Posts: 70
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.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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.
Joined: 18 May 2010
Online Status: Offline
Posts: 70
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.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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?
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
IP Logged
