Thursday, June 11, 2009

SQL Server Report based on an ad hoc query

In my previous article on DotNetSlackers site I described creating an EnterpriseDB Linked server on SQL Server 2008. In this article the idea is carried forward to create a SQL Server 2008 report based on a distributed Ad hoc query using data on the SQL Server 2008 and a linked MS Access 2003 database. The article describes step by step the procedure to create such a report using Report Builder 2.0. The idea is generic and can be adopted for other scenarios as well.

Review the following article for more details,
Authoring a SQL Server Report Using an Ad hoc query

Do more by learning to work efficiently with SQL Server Reporting services.

* Get two free chapters of my book 'Learn SQL Server Reporting Services 2008' from the pubisher's web site.

No comments: Protection Status