# suppressing previous detail lines based on a number in section footer

I had this question after viewing Crystal Reports - Need the sum of a formula that uses 'previous' function.

The solution for the sums works well.  I have used it for my AC Qty and G Qty.
I have created the formula @Difference for the difference in the AC Qty and G Qty. ({@WPR Grp Footer AC Qty}-{@WPR Grp Footer G Qty}).  These are obtained with the 'whilprintingrecords' formulas in the referenced post.
I am trying to suppress the preceding detail line(s) if @difference = 0.
I am getting an inconsistent return of the data.  Some 0's still show.  Some with quantities show but the detail is suppressed.  I do not know what I am doing wrong.
tool-room-report.pdf
###### Who is Participating?

Commented:
Unfortunately to be able to suppress the detail section the value of the formula must be known or calculated before the detail section is reached.  Since the calculation is done in the group footer and it involves formulas which use Print Time formulas (previous) you can't do it with the formulas you have.

I can think of 2 ways to do this
1.  Use a subreport in the group header to calculate the value then suppress the details
2.  Use a subreport in the group footer to display the information for the report.

mlmcc
0

Commented:
From the PDF it is a bit difficult to see what you want suppressed.

Are you trying to suppress all the detail in the group (Item Number) if the difference is 0?

Can you upload the report so we can see what you are trying to use?

mlmcc
0

Author Commented:
Yes.  If the 'difference' in the Item Number group footer is 0, I want to suppress all of the detail rows in the corresponding Item Number group detail.
AC-vs-G.rpt
0

Commented:
Looking at the report which formula do you check for 0?

mlmcc
0

Author Commented:
@WPR Grp Footer Diff in the Group Footer
0

Author Commented:
Thank you for your help with this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.