Need a report to quit duplicating item numbers with two different values for one feild

Post Author: dougatrueb

CA Forum: Formula

Hi, I have written a report that has such feilds as the category/subcategory, item number, description, and previous qty. This report for some reason will have two values of the 'prev qty' for each item number. One of the quantities will be a value like '8' while the other value is '0'. This report will print all of the information twice in the report and have a '0' on one line and an '8' on the next line. Is there a way to tell this report to not list the information or show up in the report if the value for 'prev qty' is 0? Thanks.DougatRueb