prashant_kr (7/31/2014)
This is the BIRT blog, there they mentioned about BIRT,not the comparison between these two.
Did you read the blog post I linked to?
Of course, there are also some differences between these products. Here are some obvious ones which do not directly impact the functionality of the report:
BIRT is open source under the Eclipse Public License - Reporting Services is closed proprietary source software, subject to its own product license
BIRT is based on java technology - Reporting Services is built on .NET technology
BIRT has jdbc database connectivity - Reporting Services has ODBC and ADO .NET connectivity
Syntactically, BIRT expressions are Javascript expression - Reporting Services expression are Visual Basic .NET expressions
BIRT does *NOT* have crosstabs as of yet - Reporting Services has of course
BIRT datasources are defined on the report level - Reporting Services datasources are defined on the Report Server and/or Project level (wich I think is much more convenient than in BIRT)
A lot of output formats are available for Reporting Services - BIRT can only output HTML or PDF (I'm really missing an XML output format)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP