Tudor's WebLog

About 2 years ago, as we were wrapping up SQL Server 2005 and Visual Studio 2005, I wrote a reporting services chapter in Sams' SQL Server 2005 unleashed book , As I haven't heard from the editors for a long time, I assumed it had shared the same ill...

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...

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...

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...

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...

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...

§ 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...