Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Difference Between FIE...

Difference Between FIELDCAPTION and Include Caption

Like (0) Share

Report

Posted on 22 Feb 2018 10:15:53 by Community Member

In RDL reporting in NAV 2017 what's the difference in using FIELDCaption(MyTable.MyField) instead of Include Caption = TRUE in the Report Dataset Designer.

When should I use which one in which context, what's the be practice on this ?

I see that sometimes on some reports IncludeCaption is ticked to TRUE and sometimes fieldcaption is used, what's the design decision pattern on this ?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on 22 Feb 2018 at 10:27:50

Like (0)

Report

RE: Difference Between FIELDCAPTION and Include Caption

FIELDCAPTION function Pros: works the same way as text constants. It provides ability to transfer captions defined for table fields and to effectively use captions. Cons: just like text constants, they clutter the dataset and slow the performance of the report down.

IncludeCaption flag Pros: this flag is transferring captions of a table field to static text inside the RDCL report, the same way labels do. It works very efficiently and is very easy to maintain and develop. Cons: does not work when you need to dynamically change the report language in the middle of execution or you have custom captions for a field.

<table name>.FIELDCAPTION(<table field name>) is useful if you need to switch the report language dynamically, otherwise using IncludeCaption is the best choice for performances.