Download of reports as .csv format broken

[sleidig]

Describe the bug
When downloading a report result as .csv the output format is forcing all data into a single column, putting addtional headers "Name,Value" on top of everything. The download for the old client-side reports work correctly but the server-side calculated reports (ReportConfig.mode = "sql") have this issue

Sample csv output (broken):

Name,Value
"eventStartDate: 2024-12-01, eventEndDate: 2024-12-03, eventStatus: Implemented, eventType: Traini..."

To reproduce:

1. Visit the "Reports" section (in a system where server-side reports are enabled): https://dev.aam-digital.net/report
2. Execute a server-side (mode: "sql") report (e.g. in dev system select "Beneficiary (Individuals) [SQL]" report)
3. Click "Download" and try to open the file in a spreadsheet application (does not show columns as expected)

---

Suggested Implementation Approach:

1. Write unit tests for SqlReportService.getCsv() to have an easy way for testing without having to run the whole backend report server
2. change the return type of SqlReportService.getCsv() to something more specific than any
3. Make corrections to the getCsv method
4. Check about the formats for the two version of sql reports that we have (v2 has some special structure for nesting - get support from @tomwwinter who originally implemented this, if needed)

[aam-digital-ci]

🎉 This issue has been resolved in version 3.46.3-master.3 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

[aam-digital-ci]

🎉 This issue has been resolved in version 3.47.0 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀