Is it possible to have a copy of the rdl files used to create the built in reports, as some of the formatting is incorrect and I would like to change some of the reports.
What is the SQL query used to generate the data from a specific report?
All the .rdl files are stored in orc.ReportFiles table in the database. Customers can change them if they wish, but don't encourage them. Make them aware the changes could be lost in future releases if our development team updates them. Also, whatever is changed won't be supported by Access.
You can copy the XML (within the ReportFile column) and see which SQL queries are used to generate the data for the reports.