Group Footer will not suppress
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22858
Printed Date: 02 May 2024 at 4:31pm
Topic: Group Footer will not suppress
Posted By: chudok
Subject: Group Footer will not suppress
Date 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.
|
Replies:
Posted By: DBlank
Date 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?
|
Posted By: chudok
Date 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.
|
Posted By: DBlank
Date 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.
|
Posted By: chudok
Date 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.
|
Posted By: DBlank
Date Posted: 03 Feb 2020 at 8:33am
|
what is your suppression criteria (formula)?
|
Posted By: chudok
Date Posted: 04 Feb 2020 at 1:49am
Not({SO_PickingSheetWrk.CustomerNo}like "HDCOM")
not like a certain customer.
|
Posted By: DBlank
Date 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?
|
Posted By: chudok
Date Posted: 04 Feb 2020 at 2:26am
|
Suppress footer for all customers in that group that are NOT "HDCOM"
|
Posted By: DBlank
Date 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?
|
Posted By: chudok
Date Posted: 04 Feb 2020 at 3:27am
|
yes that is correct on the order of the groups and it is group 3 footers that i am trying to suppress. So do i have to set my text up under the footer for group 2'Customer'?
|
Posted By: DBlank
Date Posted: 04 Feb 2020 at 3:34am
You have to suppress both and in theory group 1 footer if all the customers in that division are in your suppression group.
However, I think you are trying to suppress all parts of a group from header to footer for all of group2 and group 3 so why not just exclude those groups using a group select criteria on group 2?
For group 1 suppression you will need to suppress all parts based on checking the count of customers not in your suppression criteria.
Create a formula field
if Not({SO_PickingSheetWrk.CustomerNo}like "HDCOM") then 1 else 0
sum this at group level 1
suppression is then sum(formula,group1)=0
|
Posted By: hilfy
Date Posted: 06 Feb 2020 at 4:39am
Do you need all of the suppressed data in the report? If no, why not just use the Select Expert to only pull in the data where {SO_PickingSheetWrk.CustomerNo}like "HDCOM"?
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: chudok
Date Posted: 14 May 2021 at 4:53am
|
so I have something similar to this. I have a report that has a repeating header. But now I want to add a sub-report in one of the footers and I do not want the main report header to repeat onto the sub-report. how do I stop that?
|
Posted By: wsc27
Date Posted: 14 May 2021 at 5:34am
|
Did you try going to edit subreport, then suppressing the report header?
|
Posted By: chudok
Date Posted: 14 May 2021 at 6:18am
But the report header is on the main report. I want it to show for everything that is on the main report for all pages, but I do not want it to show up on the page of my sub report which is in a report footer section on the main report.
How do I say if footer contains sub report do not include the report header from the main report onto the pages that the sub report prints on.
so the main report is an invoice per say - and the sub report is just instructions with its own different header.
Now it is printing both headers when it prints the sub report. I thought even if I take the data out of the sub report and just put it directly into the the footer section - is there a way to stop the header from printing only on that footer
|
|