Motility Software Idea Board

Export reports to Excel - in a format that can be utilized

I would like to see much better compatibility with reports exporting to excel.  There are merged cells, page numbers in the middle of the data-set, multiple data columns under a single merged heading etc.

In order to use the data for anything useful, it requires tons of cleanup.

If the system could export the information in a single table, the user could setup formulas, graphs and charts, pivot tables, etc. without a hassle.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Apr 30 2019
  • Under Review
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    13 May 19:19

    The excel exports should be data exported, not the report exported. Currently, you are unable to just slap on a filter and sort. Since the export is just the report exported to excel there are many merged fields and unfilterable data. It would take 2 days to set the information in a format that is usable.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    22 Aug 18:22

    Agreed. First all cells need to be unmerged, for large data sets this can take time. Dozens of extra columns have to be deleted, many so narrow they can be difficult to select. The header fields are often spread over 2-4 rows and must be moved individually. It's a lot of wasted time every time a data set needs to be analyzed.