Integrating Servoy & Microsoft Reporting Services

Classic Servoy
1

Hi,

I’m migrating a Filemaker solution to Servoy with a Microsoft SQL Server 2005 backend. For some time now, we’ve been exporting data from filemaker nightly into a MSSQL datawarehouse that we use for some basic reporting. Now that we are switching to Servoy, we have to make a decision: Should rewrite all the reporting in Microsoft Reporting Services, or should we keep it in Servoy?

Doing it in reporting services would be nice because company executives could access the reports through a web browser, which is easier than loading up the Servoy solution. However, I imagine writing all the reports in Reporting Services will call for a lot of redundant programming, since calculated fields that will be used in the reports will have to be rewritten.

Any thoughts?

Thank you,

Andrew

2

Hi Andrew,

I wrote a free Servoy solution called “ReportWriter” that allows you to do adhoc queries with a graphical user interface. It might help you get going…

You can download from: http://developer.servoy.com/downloads/reportwriter.zip

Hope this helps.