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

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)

Owners

• nreco

Copyright

Copyright (c) 2015-2017 Vitalii Fedorchenko

Tags

• PivotData
• Pivot
• PivotTable
• OLAP
• Cross-tab
• Matrix
• Report
• Export
• HTML
• Excel
• JSON
• DataTable
• netstandard
• netcore
• net40
• net45

Dependencies

• .NETFramework 4.0

  • CsvHelper (>= 2.15.0.2)
  • EPPlus (>= 4.0.4)
  • Newtonsoft.Json (>= 9.0.1)
  • NReco.PivotData (>= 1.3.4)

• .NETStandard 1.5

  • CsvHelper (>= 2.15.0.2)
  • NETStandard.Library (>= 1.6.0)
  • Newtonsoft.Json (>= 9.0.1)
  • NReco.PivotData (>= 1.3.4)
  • Shaman.EPPlus (>= 1.0.1.1)
  • System.Data.Common (>= 4.1.0)
  • System.Reflection (>= 4.1.0)
  • System.Reflection.Primitives (>= 4.0.1)
  • System.Security.Cryptography.Algorithms (>= 4.2.0)
  • System.Security.Cryptography.Cng (>= 4.2.0)
  • System.Threading (>= 4.0.11)
  • System.Threading.Tasks (>= 4.0.11)
  • System.Threading.Tasks.Parallel (>= 4.0.1)
  • System.Xml.ReaderWriter (>= 4.0.11)

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