30 Aug 2014 8:25 AM Basic objects of Excel Reports functionality in RU localization of NAV 2013 R2: Type ID Name Description Table 14919 Excel Template Table containing templates. Fields: Code, Description, File Name, BLOB, File Extension Table 14930 Excel Template Sheet Table containing Excel template sheets. Fields: Template Code, Name, Paper Height Table 14931 Excel Template Section Sheet sections. Fields: Template Code, Sheet Name, Name, Height Table 14932 Excel Template Sheet Buffer Codeunit 14930 Excel Report Builder Manager Codeunit, which creates output Excel printing form based on specific template using DotNet component Microsoft.Dynamics.NAV.RU. ExcelReportBuilder.ReportBuilder Page 14919 Excel Templates Main templates managing page Interaction of objects: Page for working with templates: Example of functionality - 12411 Order Factura-Invoice (A) Objects (except basic stated above): Type ID Name Description Report 12411 Order Factura-Invoice (A) Invoice Report Codeunit 14931 Factura-Invoice Report Helper Codeunit, which contains the functionality of the report building (General functionality for several near-functional reports) When you import a template related data tables Excel Template Sheet, Excel Template Section are populated automatically. On the basis of the data in these tables in the CU Factura-Invoice Report Helper adds sections through the ExcelReportBuilderMgr. AddSection and populating the data section by function ExcelReportBuilderMgr. AddDataToSection. Functionality of building reports examines height of sections and automatically adds new pages when it’s needed. For Example: All the sections must be named: Dynamic lines of document are populated in the same way: You can find further information in MS Dynamics NAV documentation or by examining functionality in RU demo database. I’ll be happy to answer any questions regarding this functionality. Don’t hesitate to ask!