英文:
How to migrate Navision Microsoft Dynamics report to SQL
问题
我可以访问Navision SQL Server数据库和相应的Microsoft Dynamics NAV界面。
我想迁移‘Aged Acc. Receivable DII’报告。一旦我选择报告并转到“工具”>“设计师”，我可以看到“DataItem”列表，当我选择其中任何一个并按F9键时，我会看到如下的C/AL编辑器。
选择另一个“Data Item”会提供另一个代码。我的初始问题是，来自“Data Item”的哪个代码与“Aged Accounts Receivable - IRES”窗口中的“预览”按钮相关？
从代码中我了解到有3个表连接在一起（Customer、Cust_ Ledger Entry和Detailed Cust_ Ledg_ Entry），但我无法输出与界面中生成的报告相同的结果。我猜想这是一个通用报告。是否有一个查询可以用来生成相同的输出？或者有关如何创建报告的文档？
英文:
I have access to the Navision SQL Server database and the corresponding Microsoft Dynamics NAV interface.
I want to migrate the 'Aged Acc. Receivable DII' report. Once I select the report and go to Tools > Designer I can see the 'DataItem' list, and when I select any of those and press F9 I see the C/AL Editor as per below.
Selecting another 'Data Item' provides another code. My initial question would be, which code from the 'Data Item' refers to the 'Preview' button in the 'Aged Accounts Receivable - IRES' window?
From the code I understand there are 3 tables joined (Customer, Cust_ Ledger Entry and Detailed Cust_ Ledg_ Entry) but I can not manage to output the same result that in the report produced in the interface. I'm guessing this is a generic report. Is there a query that could be used to generate the same output? Or documentation that would explain how the report is created?
答案1
得分: 1
抱歉，我不能回答你的要求。如果你需要中文翻译，请提供具体的文本，我会尽力提供翻译。
英文:
Oh man, i don’t know where to start. MS seems to finally buried Navision 5 along with it’s documentation on msdn. But it is still should be possible for you to open local documentation with F1. Just make sure you are pressing it while your input cursor is on the code. This will open developer’s docu. You will not find there any explanations about how data is structured for output, but you will be able to find how things works.
Back to your questions. You need all the code you see in triggers. And might happen you will need code from the layout that you have not yet discovered. Preview and print buttons doing the same except for the global variable CurrReport.Preview is set to true.
To see if there is any other code open View-Sections, select any section and F9. Code will also be different per section.
The form you are asking is called RequestForm, hence the menu called View-Request page. F9 on the page and any elements on it.
Also, see the button that is third from the right on toolbar on your screen. That is Properties. Many things have properties. For example DataItem’s properties will tell you have child and parent are linked.
If you can open report in the designer then you probably have a developer’s license uploaded to database. Where is the developer then?) It should also allow you to export objects to text file. The you will be able to read every last bit of the code. When window with dataitems is active (for previously mentioned commands as well) press File-Export and select text format. Fob will produce binary output, not useful for you.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论