Creating and viewing a SQL Server 2005 Reports using a dynamic connection string

In this project we will try to make a report which can use a dynamic connection to a Northwind Catalog hosted in different SQL Servers.

This report is going to query the Employee Table in Northwind Database for the following fields:

· EmployeeID

· FirstName

· LastName

The query is as follows

SELECT TOP 10 EmployeeID, LastName, FirstName

FROM Employees

STEPS:

1. Creating the Report Parameter for supplying connection string to report.

2. Creating the Datasource

3. Creating the DataSet

4. Creating Fields in Report DataSet

5. Finalizing the report

Check the following link for the details

Additional resources