Oracle 7.3 - Oracle 21c Windows 11 compatible Version

Oracle Excel grouping retained in export and computed totals

30 Sep 2018

Data grouping withing Oracle Excel export now can be retained. As you may rememeber, column groupings are available both in Hora’s data content browser and SQL result set view.

The data content browser shows data of the COMPANY table within the HR schema. To enable enhanced grouping capabilities, we activated the “in-memory grid mode” by clicking the appropriate checkbox in the top-right of the data content frame. Data is grouped by CITY by dragging the appropriate column header into the group-by box in the top of the data grid.
You can right-click either footer or group footer to add totals or group summaries. Since our sample data do not contain any numbers that make sense to be summed up, we add a “Count” aggregate function to any column of both footer and group footer.

You can see the computed totals in the hardcopy.‍
Now right-click and choose “Excel export”. After confirming the suggested file name, MS Excel comes up, provided that it has been installed on your machine.

You can see two enhancements in KeepTool 14

  • You can now collapse/expand grouping areas in Excel that have been defined in Hora’s Oracle data content grid.
  • Totals and subtotals are computed by formula now. If you change underlying data, totals refresh automatically.