Small and medium business | Business Central, N...

How to adjust (reduce) line spacing in Sales Order/Invoice etc. reports?

(0) Share

Report

Posted on by chris_7777au

Hey community.

Can someone help me with this because it's bugging me. On a standard Business Central sales or purchase report (be it a sales quote, sales order, sales invoice or purchase equivalent), there's a massive air gap between the repeating lines (i.e. the order lines, not the header fields). I've done my best to reduce this to it's absolute minimum but there's still something padding the main control (the one holding the individual line controls). Under normal circumstances I can get away with this, but we have a number of products that have 5 or more extended text(s), and if you pad each one, each 'row' can be up to 10cm high.

Here's what I have in the report template.

Screen-Shot-2022_2D00_06_2D00_06-at-1.52.32-pm.png

Anybody got any ideas how I reduce this spacing? I've done the obvious, made sure there is no value in row height etc.

Thanks for your assistance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi chris_7777au ,

Can you please try to reducing the line spacing on the Item line?

thanks.

Was this reply helpful? Yes No
chris_7777au 95 on at

Like (0)

Report

When you say "reducing the line spacing", I have tried the following.:

1. Row Size = No specified height. I tried with a 0.20cm but that didn't help

2. Cell Margins top & bottom are set to = 0

I tried to drag the height of the row, but that's as narrow as I can go (it won't allow it to go any smaller in height). I can make it bigger, but there's a limit to how much I can reduce the height (there's still a bunch of padding).

Is there any other location to set the line spacing of the item line?

Was this reply helpful? Yes No
Alec Gray 30 on at

Like (0)

Report

Can't say that this is normal behaviour... I've just checked with the inbuilt Sales Quote and the line height, after stretching the table to avoid word wrap, seems to be less than you're seeing:

What happens if you delete the table row and re-create it?

Link to how to create repeating lines here: How to Add Fields to a Word Report Layout - Business Central | Microsoft Docs

Was this reply helpful? Yes No