Comparison with Crystal Reports

I showed my boss the functionality of ad hoc reporting in SRSS and he likes it. He asked me if we could completely move away from Crystal Reports (CR) to SRSS.

Does anyone have any issues with SRSS that didnt exist in CR.

One question i have is programmability capabilities. Some time back i had to make a very complex report in CR. I create a table in the dataset. Designed the report to pull data from that table and the table was being populated through some VB.NET code. So the users will open a GUI and hit RUN, which is when i will populate the table and show the report. You can assume that populating the table required complex programming and couldnt have been done through user defined functions in a report.

I dont suppose stuff like this can be done in SRSS?

Depending on the version of Crystal you have, there are various differences, though it is a good path to move to in my opinion.

Here is one summary I have found outlining differences:

http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp

There's lots of information out there on this.

It is also possible to use a dataset as the source of report data in a custom application with Reporting Services.

cheers,

Andrew