The reports from M-Files to an external database are created by using the Microsoft SQL Server Reporting Services infrastructure, which must be implemented and configured correctly.
When reports have been created and they are to be used in M-Files, the SQL Server Reporting Services system contacts the database to which the data export was done from M-Files, creating a report when M-Files Desktop so requires.
Microsoft's SQL Server Reporting Services infrastructure can be installed with the SQL Server installation package (SQL Server 2008 or SQL Server 2008 R2).
Also the SQL Server Express versions can be used in reporting. Then select the SQL Server 2008 R2 Express with Advanced Services installation package. You can download it via Microsoft's web site at http://www.microsoft.com/express/Database.
For more information, refer to http://msdn.microsoft.com/en-us/library/ms159106.aspx (SQL Server Books Online).
In planning the reports, you also need Business Intelligence Development Studio or, a simpler tool, Report Builder. The person planning the reports must be experienced in this and have the skills required for creating reports. Please contact our consulting services personnel, and we will be happy to help you with planning of the reports ([email protected]).
For more information on installing Microsoft's reporting services, please consult Microsoft's web pages and the M-Files customer support staff at [email protected].