When exporting reports to Excel, the reports should be organized in columns and rows (possibly repeating information) rather than in "Report" format.

The reports that are built in are almost always impossible to use for any kind of data/filtering/analysis purpose because they don't obey the simple structure of an excel table (rows and columns) when exported in Excel format.  Instead they export in a "printable" format that tries to be a Word document or PDF in Excel.  We currently have to rebuild all of these reports with advanced lists in order to get the data in a usable format.

  • Nathan Still
  • Nov 15 2018
Blackbaud Student Information System / Lists & Reports (oR)
  • Attach files
  • john ronan commented
    March 14, 2019 20:50

    e.g. student conflict report

    Attachments Open full size
  • john ronan commented
    March 14, 2019 20:50

    The main reason for exporting to Excel in the first place is to do just this kind of data/filtering/analysis.   If you insist on exporting Excel in report format, then provide a 'Data Only' style export that gives what is described above.

    Attachments Open full size

Related ideas