Before we get started on actually writing our local report, we should delve into the database that we will be using. As with most example applications we will be working with the Northwind database.  We will write a report based on the Customers and Orders Tables. I will be demonstrating this using parameters and without using parameters. The basic query that I will be using in both instances is below.

Listing 1

Select OrderID,
       OrderDate,
       ShippedDate,
       CompanyName,
       ContactName,
       ShipName,
       ShipAddress,
       ShipCity,
       ShipRegion,
       ShipPostalCode,
       ShipCountry
from   Customers cst
inner join Orders od on
      od.CustomerID = cst.CustomerID 

First, I will create a new website called SSRSExample.  I will be using Visual Basic 2005 as my development language. Also, since this is an example, I am going to go light on the design and focus more on the process of creating the report.

Figure 1