Reports Manager reports exported to Excel should not have data in merged cells

Enhancement Brief Description From Report Manager, when one exports reports to Excel, data elements in Excel are in merged fields, and, because of this, the exported report cannot be manipulated without a lot of spreadsheet cleanup. Current Function Presently in Report Manager, there is no way for a client to specify what fields are desired for the report, no way to sort the data on organization name or submitted date.  And, when it is exported to Excel, data elements often times go into cells that are merged in Excel. Desired Function 1. When in Report Manager and exporting to Excel, in the export file, each row/columnar data should be in its own cell. not in merged cells. 2. In the canned report "Submitted Requests", add a field for the Request Amount. 3. Within Report Manager, allow client to specify fields to be included (such as Request Amount) 4. Add ability to sort the report data alphabetically by Organization Name and/or date submitted (either in descending or ascending order) within the report manager. Reason For Function Currently, it takes clients many hours to cleanse the spreadsheet data, unmerging cells, etc., before it can be sorted, manipulated, etc. Priority Medium  
  • Guest
  • Aug 11 2015
  • Reviewed: Voting Open
  • Attach files
  • Barb Ford commented
    March 21, 2022 22:00

    It shouldn't add the column headers to every page in Excel.

  • Guest commented
    August 30, 2017 01:22

    Makes the spreadsheet useless in some cases.

  • +10