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
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.
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
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.
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
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.
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 ?
please restart the nav 2015 service, eventually delete the acc. object cache. then try again.
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.
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.
Hi, Saurav.
Yes, those are the values of the caption fields.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156