web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to collapse empty ...

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

Suggested Answer

How to collapse empty spacing in word report layout?

(0) Share

Report

Report

Posted on by jdrco

485

Right now I have all of the Customer Addresses in my report layout like so:

Screen-Shot-2022_2D00_05_2D00_19-at-8.58.54-AM.png

But I if a customer doesn't have all 8 addresses, I don't want empty space to show up in my report. Right now it is showing empty space since this specific customer doesn't have all 8 addresses:

Screen-Shot-2022_2D00_05_2D00_19-at-8.59.00-AM.png

How do I go about doing this? (I don't want to do this using a .rdlc so if I can get guidance on how to do this with AL and Word, that would be great).

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi jdrco ,

You can try following expression in your text box visibility property.

iif(Fields!CustomerAddress2.value-"",true,false)

Try this if it helps

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 647 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans