Options

IncludeCaption on field item which is not part of the DataItem

Tarek_DemiatiTarek_Demiati Member Posts: 112
edited 2018-03-13 in NAV Three Tier
On NAV 2017 it seems that it's still not possible to get IncludeCaption on RDLC report to work when the field reference is not part of the dataitem (ie : Item) but coming from a global variable such as Weigh_ItemUOM ?

I keep on getting the Weight_ItemUOM variable printed instead of the actual caption value.

Does anyone know if this has been fixed in a cumulative update ?

Working with FIELDCAPTION and TextConstant ML is clearly not a super productive solution when your reports must work on multiple languages.

Answers

  • Options
    Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    This is not something which is going to be fixed, me thinks.

    The RLDC and NAV are two separate worlds. The FIELDCAPTION concept is a NAV thing, the NAV metadata. RDLC knows nothing about it, as the RDLC is a general reporting tool/language. That's why you have to prepare your captions as a part of the dataset. RDLC treats them just as another data. Hence the 'funny' functions all around the place in standard RDLC reports to pick up the correct data from the source data set

    Although Microsoft did a lot of things to make it look like the RDLC reports are part of NAV, in reality, what NAV does during printing is only preparing a flat file with all the data in the background, and then feeds this file as a data source to the report viewer.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Sign In or Register to comment.