Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Include Caption option...
Microsoft Dynamics NAV (Archived)

Include Caption option not working properly in a report

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, all.

I have a problem with Include Caption option in a report.

Report is 722 Phys. Inventory List. In Data Item "Item Journal Line" there are fields DocNo_ItemJournalLine, ItemNo_ItemJournalLine, Desc_ItemJournalLine, LocCode_ItemJournalLine, QtyCalculated_ItemJnlLin and BinCode_ItemJournalLine which all have Include Caption property set. When the report is run, proper captions for those fields are not showed, but the names of the parameters are shown instead (DocNo_ItemJournalLineCaption, ItemNo_ItemJournalLineCaption, etc.).

Report is not modified in any manner. Its version is NAVW17.10.00.40076. On a different database, the same report with version NAVW17.10 is showing captions properly. I've compared the versions and I don't see any difference that could be relevant.
I've also tried reseting the caption, removed it from the layout, removed the mark from option Include Caption, complied the report, added it again, but no use, same problem again.

I hope someone could help me, because it would be realy tedious work to switch from Include Caption to manualy added Labels in all of the reports where I may encounter this problem again.

*This post is locked for comments

  • Ryden Profile Picture
    Ryden 10 on at
    RE: Include Caption option not working properly in a report

    Since its been almost two years, you've probably sorted this problem one way or another.

    But I was just wondering if you ran your report on a temporary table?

    That results in the exact behaviour you describe, for some reason Include Caption only works on normal tables.

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Include Caption option not working properly in a report

    it seems that no suggestion did solve your issue.

    so i think, if this is a major issue for you, your options are:

    - update to a newer or maybe the newest CU, then try again.

    - start from scratch with a new database

    - use labels instead of includecaption

    - check, when this issue started and restore a backup of your database before that issue occured

  • Community Member Profile Picture
    Community Member on at
    RE: Include Caption option not working properly in a report

    Looks like that this problem is database-specific, not object-specific.

    I've created a new report, with Data Item Currency and its field Description. Checked the Include Caption option. Added one textbox to the layout that should show the value of DescriptionCaption parameter.

    Printout has the same problem like the report 722.

  • Community Member Profile Picture
    Community Member on at
    RE: Include Caption option not working properly in a report

    Hi, guys.

    Like I've said, it's the standard report, without any modifications on our side and it must work as it is. Adding code for language can't be proper solution.

    Anyway, I gave it a try, just to see if it works and it doesn't. I've tried everything else you've suggested: deleted metadata, recompiled, restarted the service - no use.

    I've tried to delete Object Metadata for table 83 Item Journal Line, because captions from that table are the problem, but NAV doesn't let me to do that. I get an error "Modifying the content of the Object Metadata table is not supported. Use the Microsoft Dynamics NAV Development Environment to make changes." I could delete metadata for the report though.

    NAV version/build is 7.10.36897

  • 4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Include Caption option not working properly in a report

    Hi Srđan,

    I faced the same issue when developed a report in 3 languages. Did you try to add mentioned code by Mahesh:

    CurrReport.LANGUAGE := Language.GetLanguageID("Language Code");

    Take a look at report 206 Sales - Invoice for example.

  • Suresh Kulla Profile Picture
    Suresh Kulla 44,656 on at
    RE: Include Caption option not working properly in a report

    Try to delete the metadata for that report from the object metadata, user metadata, page data personalization and re-compile the report.

    What is the Navision build you are running ?

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Include Caption option not working properly in a report

    please restart the nav 2015 service, eventually delete the acc. object cache. then try again.

  • Community Member Profile Picture
    Community Member on at
    RE: Include Caption option not working properly in a report

    Hi, Makesh.

    1. There's no such code for setting report language dinamicly in this report.

    2. Yes, it's set.

    3. Related fields in table Item Journal Line all have correct ML captions.

  • mmv Profile Picture
    mmv 11,467 on at
    RE: Include Caption option not working properly in a report

    Hi,

    1. Do you have the method called:

    CurrReport.LANGUAGE := Language.GetLanguageID("Language Code");

    2. In Visual Studio on the report properties is your language set to this

    =User!Language

    Not sure why, but sometimes mine have changed to a specific language.

    3. Also remember that when you use include captions, it takes them from your table since you have no option to give captions in the report on a field (eg. dont mistake OptionCaptionML with CaptionML in the properties).  As you have mentioned that you checked it in a different db, please check the related tables too.

    It is a bit anoying, since if you want to translate a document to german and you dont have that as a client language, then you cant just add the german labels but you have to create text constants with "all" the languages.

  • Community Member Profile Picture
    Community Member on at
    RE: Include Caption option not working properly in a report

    Hi, Saurav.

    Yes, those are the values of the caption fields.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans