277

Downloads

97

Downloads of v 1.3.3

2

Average downloads per day

2016-12-02

Last published

Share on Social Networks

NReco.PivotData.Extensions

1.3.3

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

Release Notes

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

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)

v.1.3.1 changes:
- published NReco.PivotData.Extensions nuget package; it needs a license key to remove trial limitations
- CubeKeywordFilter enhancements: starts-with / ends-with syntax ( *keyword, keyword* ), dimension hints syntax (year:2015)
- PivotTableExcelWriter is now available in netstandard build (for .NET Core apps)
- added more formatting options to ExcelWriter and CsvWriter (FormatKey/FormatValue)
- fixed PivotTableJsonWriter JSON serialization issue (null and DBNull values)
- fixed PivotTableDataTableWriter nullreference exception when MinAggregator or MaxAggregator is used

Owners

Authors

Vitalii Fedorchenko

Copyright

Copyright (c) 2015-2016 Vitalii Fedorchenko

Tags

Dependencies

Version History

Version Downloads Last updated
NReco.PivotData... 1.3.2 117 Tuesday, October 18, 2016
NReco.PivotData... 1.3.1 63 Friday, September 16, 2016