we are currently evaluating SSRS and its features for making a decision on migrating from Crystal. I have read up on SSRS a bit and just need some confirmation on some of my findings.
My company develops Windows applications, distributable via MSI files. The backend is SQL Server 2008. We are currently using Crystal Reports to display reports to the end user using the Crystal .NET viewer control. Crystal Reports are saved as .rpt files
and contained in the msi file, therefore deployed to the clients.
As we are considering migrating away from Crystal, I had a look at SSRS. It is my understanding that there are two ways of using reports: First, in local mode, which is similar to the way Crystal works: Client-side deployed report files. However, unlike
Crystal, the application has to retrieve the data for the report from the database and pass a dataset to the viewer control whereas in Crystal, you just point the report viewer to the database you want to use and it pulls the data itself.
The other mode, remote or server mode, has the reports stored in the report server (i.e. SQL Server). The viewer control will be set to the URL of the report, and the report then pulls the data from the SQL database. I am unsure to how you could deploy reports
onto the Report Server using a MSI package; it sounds like quite a bit of work as the only way I have found by now is to consume webs
View Complete Post