Skip to content

RDS based reports with same table names caused SQLite errors

What is new - 25.0

When an RDS based report contained a sub-report with the same RDS table name, errors such as "DataFlex Reports error. Error: 1, no such column: User.TicketCount (0)" were generated. SQLite table names are now unique per (sub)report. Ensure your reports have unique report IDs (GUIDs) and use the maintenance tool if new GUIDs are needed or desired.

Additionally, loading two RDS based reports with the same RDS table name but with a different number of columns or names also resulted in the aforementioned error. This issue has now been resolved.