Ranet HTML Pivot Table

Release History

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


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


  • 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


  • 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
Write US