My experience with the relatively new Telerik reporting solution has been very positive. In order to create a report you simply need a 3 dll’s within your solution and a data source.
The data source can be ANY ADO.NET data source as well as business objects, XML, Web Services etc. As the data source can be any ADO.NET source the reporting solution works against SQL Server, MySQL, Oracle, Access, OLE DB etc.
I have been a big fan of SQL Reporting Services for quite a while (moving to SQL RS many years ago as I ran from Crystal Reports). Unlike SQL RS it is a very fast install on local development workstation and nothing on the server is required. The product is licensed by developer making utilization by the enterprise not dependent on the number of users. This really works out well in the Internet type environment.
I found the the designer (within Visual Studio) to be very fast and easier to use that SQL RS. The drag and drop features and the visual clues are clearly superior than other reporting solutions I have used.
Telerik Reporting supports the most commonly used output formats out-of-the-box: PDF, Excel, RTF, CSV, MHTML, BMP, GIF, JPEG, PNG, TIFF and metafile (EMF).
The Telerik product certainly makes it easy to find the data source, connect within Visual Studio and drag and drop the fields onto the design surface.
More information can be found online at Telerik Reporting