Ask Your Question

Base reports remove empty lines

asked 2019-06-06 20:26:45 +0200

jodybingo gravatar image

updated 2020-09-03 13:43:12 +0200

Alex Kemp gravatar image

i am using the LO v 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
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-06 20:44:37 +0200

Ratslinger gravatar image

updated 2019-06-06 21:21:58 +0200


Use the Conditional Print Expression on the detail line:


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


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

image description

Now eliminating records where Material ID = 3:

image description

No blank line appears!

Report setting:

image description

edit flag offensive delete link more


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

Ratslinger gravatar imageRatslinger ( 2019-06-06 20:54:14 +0200 )edit

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

jodybingo gravatar imagejodybingo ( 2019-06-06 20:58:05 +0200 )edit

@Ratslinger, gotcha!!

jodybingo gravatar imagejodybingo ( 2019-06-06 20:58:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-06 20:26:45 +0200

Seen: 123 times

Last updated: Jun 06 '19