BC14 Word Layout – How to Hide Empty XML-Mapped Fields?
I’m working on a Word layout in Business Central 14 that uses XML-mapped content controls (from the dataset). I have a field like EinsatzortBeschreibungLineTextWord, and I want to hide it if it’s empty so that no blank lines or labels appear in the document.
I tried using an IF field like this:
"{ IF "«EinsatzortBeschreibungLineTextWord»" = "" "" "«EinsatzortBeschreibungLineTextWord»" }"
…but it always prints nothing, even when the field has data.
What’s the correct way to conditionally show a mapped content control in Word layouts?
- Do I need to use bookmarks and REF fields?
- Or is there a better approach for BC14?
Any tips or examples would be greatly appreciated!
Answers
-
Hi!
I try in standard report 110. Make field like this - {IF CustAddr_1__1_="" "111" "222"} - it works. But when it open file this fields will be empty and you need Update fields. after this they will calculated and shown.
Also if i choose print PDF it also dont calculated
I try with set up auto calculate fields - but in word they automaticly calculated only when you print document.
Also try with script on VB, but BC cannot create file with script (in my case)
So you can use it - but need to refresh manualy, or it can be refreshed before printing from word
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 327 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
