The wait is over. The new edition of SQL Express - (free) that includes Reporting Services is available. Look here for download details. For a list of features available in all SQL editions see this article Happy reporting!

I made a couple of changes in the object data source sample on www.gotreportviewer.com to illustrate the use of nested objects in report fields I have added a ProductSales sub-class to the Product class. ProductSales has two fields: Quantity and Price. In the report - you can reference them via...

Great starting point for using the new Report Viewer controls in Visual Studio 2005 http://www.gotreportviewer.com/

Deploying Report Manager on an Internet-Facing Web Server I have seen a lot of questions on deploying Reporting Services in an internet facing configuration. In SQL Reporting Services 2005, this is easier than in the previous version, but still not as seamless as we would have liked. In SQL Server...

If you grant Reporting services permissions (via http://servername/Reports | folder properties | security) to Windows security groups, you may find out that people belonging to those groups don't immediately get the expected access rights. For performance reasons IIS caches authorization tokens. For...

I have seen enough questions on how to protect parameters passed to reports to warrant a blog entry. Let’s say if you want to integrate a report containing HR data in your application. Let’s assume the data in the HR database is keyed by the EmployeeID field. Your application will...

If you upgraded to RS SP1 and noticed some of your reports that used to work fail now with the following error: “The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting...

§ Optimize your report queries. Usually the bulk of report execution time is spent executing queries and retrieving results. If you are using SQL Server , tools such as Query Analyzer and Profiler can help you optimize your queries and Database Tuning Advisor can suggest better indexes for your...