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
slmcManufacturing ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
slmcManufacturing ManagerAuthor 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
mlmccCommented:
Looking at the report which formula do you check for 0?

mlmcc
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

slmcManufacturing ManagerAuthor Commented:
@WPR Grp Footer Diff in the Group Footer
0
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slmcManufacturing ManagerAuthor Commented:
Thank you for your help with this.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.