| Docs Help
  AppSource  
  The topic is not available for the selected language ().
Docs  /  Excel Report Builder  /  Appendix

 Comparison with BC Standard and NC Cube


2024/11/22 • 4 min. to read
Would you like to know what advantages the Excel Report Builder offers compared to the Business Central Standard? In the following list you will find a comparison with the Business Central Analysis mode, the Business Central Export to Excel functionality and the Dynamics NAV AddOn NC Cube.
 Excel Report BuilderAnalysis modeExport to ExcelNC Cube
Availabilityas of BC 14as of BC 23all versionsonly for NAV
CompatibilityExcel, OpenOfficeCannot be exported to ExcelExcelExcel
TechnologyCalculation on the server,
Excel does not need to be installed for this
Calculation on the clientCalculation on the client,
Excel must be installed on the client for this
Calculation on the client,
Excel must be installed on the client for this
Independent of language, region and country settingsPartial
Maximum number of linesunlimited100.000 (default)
Performance problems with large amounts of data due to browser-based system
50.000 (default)
Maximum: 1.000.000
1.048.576
Evaluable tablesAllOnly if a page of type List exists for the table.Only if a page of type List exists for the table.All
Evaluable fieldsAllOnly displayedOnly displayedAll
Evaluations can be savedLimited as page viewLimited as page view
Evaluations can be shared with other users--
Evaluation archive--
Evaluations can be scheduled (incl. Report Inbox)---
Cross-company evaluations--
Several worksheets per evaluation---
Number of tables per evaluationunlimited11Base table required
Table relations--
Add the same field more than once--
Filter at field level
Example: Comparison of the current sales amount with the amount from last month
--
Formulas, Excel formulas and Excel functions--
Fixed and dynamic references--
Totals calculations--
Column formatting, colors, decimal places, data bars, etc.--Partial
Pivot functionality-
Multiple pivot sheets per evaluation--
Multiple pivot charts per evaluation--
Pivot sorting, filters, subtotals--
Pivot data slicer--
Classic pivot layoutConfigurable--Configurable
Flexible date filters (placeholders)--
Parallel tree structures
Example: Combining data from different tables
---
Text sheets, information sheets--
OneDrive integration---
Connector---
Download area--
Excel templates---


Submit feedback for
DE|EN Imprint