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
