SMART Generic Excel Report
SMART Generic Excel Report generates Excel reports in Microsoft Dynamics 365 Business Central from data templates and Excel templates, without code. The variables of a SMART Data Template data template are mapped to the cells of an Excel template, repeating sections fill the table rows, and the generated file keeps the template's formatting; reports can also be printed from business documents such as personnel orders.
At a glance
- Publisher: SMART business
- AppSource listing: SMART Generic Excel Report
- Deployment: Business Central online, Business Central on-premises
- Interface languages: English, Polish, Ukrainian
- Requires: SMART Data Template
- Licensing: Licensing Policy
Capabilities
- Excel reports are designed without code: a data template from SMART Data Template provides the data, and an Excel template with named ranges provides the layout.
- The header, the lines and the footer of the template are filled in separately, and the line section repeats for every record, for example for table rows.
- Each cell of the template gets a value and its format, such as a date, a number with a number format or a Boolean, and the cells of the template are suggested automatically.
- The report produces an Excel file with the data from Business Central that keeps the structure and formatting of the template, including charts and conditional formatting.
- In SMART Payroll a report can be assigned to a document type and printed from the document, for example from a vacation order.
Get started
- SMART Data Template — create the data template with the variables the report needs.
- SMART Generic Excel Report — create the report, its sections and the cell mapping, and run it.