Base reports remove empty lines

i am using the LO v 6.2.4.2 and am trying to generate a report for a food order. My report would look something like…

3 Cheese Pizza

2 Pepperoni Pizza

12 Hot-Dogs

Now, if any one of those orders is at 0, how can I get my report to omit the entire line and move up everything else?

enter code here

Hello,

Use the Conditional Print Expression on the detail line:

["YOUR_FIELD_NAME_WHICH_HAS_THIS_NUMBER"] > 0

(Have given up asking for info - only answer where this does not absolutely apply)

Edit:

If you have a blank line still appearing it is because the condition is not on the detail line. My Test printing all records:

Now eliminating records where Material ID = 3:

No blank line appears!

Report setting:

@jodybingo As you have been helped, please help others to know the question has been answered by clicking on the :heavy_check_mark: in upper left area of answer which satisfied the question.

This omits the pizzas at 0 but the other items do not move up. It leaves an empty line

@Ratslinger, gotcha!!