Downloads of v 1.3.5


Average downloads per day


Last published

Share on Social Networks



PivotData Toolkit (extends NReco.PivotData library): advanced components for pivot table reports generation + exports (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentage/difference/topN), CSV/TSV/JSON/SQL data sources, extract-transform-load (ETL), keyword-based filter etc.

To install NReco.PivotData.Extensions, run the following command in the Package Manager Console

Install-Package NReco.PivotData.Extensions -Version 1.3.5

Release Notes

NOTE: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some limitations / trial notices).

v.1.3.5 changes:
- fixed bug in PivotTableDataTableWriter (trial notice not removed even with valid key)
- PivotTableDataTableWriter now derives from PivotTableWriterBase and supports totals row/column/grand total (configurable)

v.1.3.4 changes:
- added PivotTableHtmlWriter.SubtotalDimensions option (define which dimensions should have sub-totals)
- added PivotTableHtmlWriter.SubtotalKeySuffix option (localization of " Total" suffix added to sub-totals label)
- added new PivotTableHtmlWriter methods for advanced table cells formatting: OnWriteValueCell  and OnWriteKeyCell
- fixed issues with TopPivotTable wrapper (exception when top limit is applied both on rows and columns, avoid adding of empty "other" groups)

v.1.3.3 changes:
- added JsonSource: use JSON data (file, REST API response) as input for PivotData.
- PivotTableHtmlWriter RepeatKeysInGroups/RepeatDuplicateKeysAcrossDimensions options now can be enabled for rows, columns or both.
- added RepeatKeysInGroups and RepeatDuplicateKeysAcrossDimensions properties to PivotTableExcelWriter (they have the same affect as in PivotTableHtmlWriter).
- added PivotTableHtmlWriter.AllowHtml option (allows usage of HTML tags in table labels or cell values; false by default)
- fixed PivotTableExcelWriter output when there are no dimensions for rows.

v.1.3.2 changes:
- added PaginatePivotTable wrapper: used for effective pivot table pagination on the server-side + related internal changed
- added pagination support to front-end component (jquery.nrecopivottable.js) and ToolkitPivotReportMvc example
- added PivotTableHtmlWriter.RepeatKeysInGroups option (prevents labels grouping; false by default)
- added PivotTableHtmlWriter.RepeatDuplicateKeysAcrossDimensions option (prevents the same label merging across dimensions)
- added more formatting options to PivotTableCsvWriter / PivotTableExcelWriter
- GroupedSourceReader significant refactoring; some changes are NOT backward compatible.
- fixed FixedPivotData issue (ArgumentOutOfRange exception when PivotDataState contains only several values)
- fixed PivotTableDataTableWriter issue (appears when pivot table contains several measures)



Vitalii Fedorchenko


Copyright (c) 2015-2017 Vitalii Fedorchenko



Version History

Version Downloads Last updated
NReco.PivotData... 1.3.5 (this version) 232 Wednesday, March 15, 2017
NReco.PivotData... 1.3.4 322 Wednesday, February 1, 2017
NReco.PivotData... 1.3.3 260 Friday, December 2, 2016
NReco.PivotData... 1.3.2 181 Tuesday, October 18, 2016
NReco.PivotData... 1.3.1 120 Friday, September 16, 2016