You are now ready to create a simple Reporting Services
report that we can use to see everything in action. To create this sample
report follow these steps.
1.
Open Visual Studio 2005 and select File | New | Project.
Select the Business Intelligence Projects project type
and then select the Report Server Project Wizard as
depicted in Figure 1. Give your project a name, like SampleReport,
and click OK.
Figure
1
2.
On the Report Wizard Welcome screen (if you get
one), just click Next and then create a new data source
pointing to your AdventureWorks database. To do
this, give your data source a Name of AdventureWorks, then click the Edit
button and provide the needed configuration. Once completed, your results
should look similar to those in Figure 2. Click Next
to continue.
Figure
2
3.
Paste the following SQL statement into the Query string
box in the Report Wizard and click Next.
Listing
1
SELECT
loc.Name [Location],
prod.ProductNumber [Part Number],
prod.Name [Part name],
prod.ReorderPoint [Reorder Point],
inv.Quantity [Current Count],
prod.ReorderPoint - inv.Quantity [Deficit]
FROM
Production.ProductInventory inv
INNER JOIN Production.Product prod ON prod.ProductID = inv.ProductID
INNER JOIN Production.Location loc ON inv.LocationID = loc.LocationID
WHERE
inv.Quantity < prod.ReorderPoint AND
inv.Shelf <> 'N/A' AND
inv.LocationID = @location
ORDER BY
1,5 DESC
4.
Click Next again to create a tabular report and
then move all of the available fields to the Details
section of the Table designer. Now click Next twice.
5.
In the Choose the Deployment Location page,
specify the location of your Report Server as well as any folder you would like
to use for organization. I just chose the defaults. Click Next
and then click Finish.
Once the Wizard completes the process of creating your
report, go ahead and select the Preview tab from the
designer within Visual Studio 2005. Then enter the
literal value "20" (minus the quotes) into the location field and
press the View Report button.
