
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
I have the same question (0)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.