Tag Archives: SSRS

RE8, Blackbaud Enterprise CRM and the case for Crystal

Not Code, , , ,

There has been much discussion on various forums and between different organisation about the rumour that Crystal Reports is not going to be supported on the Infinity platform. While I don’t have any inside information from Blackbaud about this I can dispel a couple of myths.

Currently in Raiser’s Edge 7, Crystal Reports is used as the reporting engine for all canned reports. Blackbaud use components that feed their data into various Crystal Reports so that you need merely click on a button and the report appears. These reports have a predefined format and although the user can change some aspects of this it is very limited.

In RE8, BBEC and the Infinity platform the canned reports do not use Crystal Reports as the reporting engine but rather SQL Server Reporting Services (SSRS). This is server based and comes with SQL Server. Blackbaud currently bundles Crystal Reports with their software but this version is client based. To bundle the server version would clearly mean a greater expense for them (and ultimately their customers).

When it comes to custom reports there is some uncertainty. I am not sure how the Infinity platform handles custom reporting. I am sure that there will be some kind of function to integrate custom reports with RE8 but most probably via SSRS.

There is a lot of investment in Crystal in the community so it is obviously of concern to think that Crystal will no longer be used. This, though is not strictly the case. It should be quite possible to use Crystal against the BBEC and RE8 database. After all Crystal can run against any kind of database. Many RE7 users develop reports that run directly off of the database rather than using the custom mechanism inside of RE. This offers much more flexibility.

One other possibility that I am currently looking into is developing a Crystal Report engine to integrate with the Infinity platform. That way data can be exported from RE8 and BBEC and linked to a Crystal Report in the same way as is currently the case in RE7. It does seem a shame to waste all the Crystal knowledge out there. Watch this space…

What are your thoughts on the shift to SSRS? Do you currently use SSRS with RE7 or other products and how does it compare to Crystal Reports. Let us know your thoughts in the comments below.