Ask Your Question
0

Base reports remove empty lines

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

jodybingo gravatar image

updated 2019-06-06 20:29:11 +0100

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
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Ratslinger gravatar image

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

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:

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

Comments

@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 +0100 )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 +0100 )edit

@Ratslinger, gotcha!!

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

Question Tools

1 follower

Stats

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

Seen: 24 times

Last updated: Jun 06