Ranet HTML Pivot Table 5.7.150

July 24, 2017

Pivot Table

• Sorting option in the pivot table; sorting visualization
• DrillThrough. Option to export DrillThrough results to Excel
• Context menu for cells; option to copy cells in the clipboard, view cell properties
• "Build Filter Axis" command that adds elements to the filter area based on the selected cells' rows and columns
• "Leave Current Structure" command that filters the pivot table based on selected cells' rows and columns

Pivot Charts

• Pie charts for pivot table data visualization
• Option to view series on separate charts, customize chart table
• Support of the main pivot table actions in the charts
• Option to show an additional axis on the chart

Member Choice

• New Member Choice filter applicable to levels
• Option to view only selected elements
• Option to view cube member properties
• Element search

Active Filters

• Horizontal scrolling in the Active filters area

Export/Import

• Report export to / import from the user's computer (XML)
• Report export to URL; opening report via URL

Toolbar

• Reset button on the Toolbar resets custom calculations and styles

Server Side

• XML comments to the server code
• Comments to Angular and JavaScript code
• Server logic virtual methods for pivot table integration into other applications
• Server DLL versioning

Design and Usability

• New design
• New dialog window for extension customization
• Botton toolbar for managing multi-page reports
• Report header and footer customization; header/footer export to Excel

Other

• Option to modify sizes of all modal windows
• Selected elements tree normalization. When the cube structure is changed the saved reports are kept operational

• Wrong filter description in the Active filters area
• Error executing MDX request when creating custom calculated elements with members from the "Non-empty behavior" editor
• Error exporting report to Excel when there is no Rows or Columns area in the pivot table
• Error in the pivot table after "Drilldown with the parent"
• Error when sorting MDX query execution result in case there are the same elements in Rows or Columns
• Error generating MDX query when a single member is selected in the Member Choice
• Error recording history when there are filters applied to the report
• Error when loading a report with saved user actions
• TreeView opens closed nodes when adding/deleting elements
• Error displaying the chart when there are negative values in the data source