web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Word Template Formatting of Blank Data and Decimals

(0) ShareShare
ReportReport
Posted on by 60

Hi,

We are using the Word Templates within Dynamics 365 and have a couple of questions regarding the formatting of the data.

Our example is an invoice so we have invoice addresses included in the Word Template, e.g. Address Line 1, 2, 3 4, 5, etc.

Not all address lines have data populated in all instances so when the template is created it puts say a blank line in the address for line 4 which doesn't look good.

How can you handle this to say if there is no data in the field then don't display it?

The second formatting issue is the formatting of numeric values, e.g. the quantity is Dynamics supports 5 decimal places so when it it output to the template it looks like 2.00000 when it should just be 2.

How can we format this?

Thanks

Tom

I have the same question (0)
  • LuHao Profile Picture
    40,890 on at
    RE: Word Template Formatting of Blank Data and Decimals

    Hi Tom2015,

    Please refer to the contents of these two posts:

    https://community.dynamics.com/crm/f/117/t/255802

    https://community.dynamics.com/crm/f/117/t/188069

    We could know from them:

    1. There is currently no OOB function to achieve the effect of not displaying the field if there is no data in it.
    2. You have to change the precision in the customizations for the quantity attribute on your entity. Word has no direct formatting method for decimals.

    1323.Capture.JPG

    Hope this helps.

    Best Regards,

    Lu Hao

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Dynamics 365 general

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans