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
slmcAsked:
Who is Participating?
 
mlmccCommented:
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
 
mlmccCommented:
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
 
slmcAuthor 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

mlmcc
0
 
slmcAuthor Commented:
@WPR Grp Footer Diff in the Group Footer
0
 
slmcAuthor 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.

All Courses

From novice to tech pro — start learning today.