Table of Contents

SMART Generic Excel Report

SMART Generic Excel Report icon 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

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

  1. SMART Data Template — create the data template with the variables the report needs.
  2. SMART Generic Excel Report — create the report, its sections and the cell mapping, and run it.