long overdue post – book & bye SQL reporting services

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-fate with many software projects – nothing I…

0

Reporting Services in SQL Express now available

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!

2

Sample on ReportViewer controls with Object data sources containing nested objects

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: Fields!Sales.Value.Quantity and Fields!Sales.Value.Price You can similarly use…

4

New report viewer developer site

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

1

Reporting Services 2005 advanced deployment options

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 Reporting Services 2005, you can…

5

Adding security groups to Reporting services security doesn’t take effect until IIS is restarted

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 more details on how to configure it, see the following KB article: http://support.microsoft.com/kb/q152526/  

4

Secure reports, parameters and User!UserID

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 figure out the value…

11

Reporting Services SP1 and rsInvalidDataSourceCredentialSetting errors

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)” here is the what to…

3

Microsoft SQL Server Reporting Services – measuring and improving performance

§       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 database. §       Measure: The Report Server ExecutionLog…

10