Find it EZ

Location: Local or Network Folders
Host: FINDITEZ-T460P
Path: C:\Users\ken\Documents\Test Cases\SSRS\Sales With OnDemand Sub_sub_subsales.rdl
Datasets
Query(s)

SELECT Employee.[First Name], Employee.[Last Name], Orders.[Order Date], Product.[Product Class], Orders_Detail.[Unit Price], Orders_Detail.Quantity, Orders.[Order Amount]
FROM ((Xtreme115DB.dbo.Orders Orders INNER JOIN Xtreme115DB.dbo.[Orders Detail] Orders_Detail ON Orders.[Order ID]=Orders_Detail.[Order ID]) INNER JOIN Xtreme115DB.dbo.Product Product ON Orders_Detail.[Product ID]=Product.[Product ID]) INNER JOIN Xtreme115DB.dbo.Employee Employee ON Orders.[Employee ID]=Employee.[Employee ID]
WHERE (Orders.[Order Date] >= '01/01/2003' And Orders.[Order Date] <= '03/31/2003') And Orders.[Order Amount] > 0 And Employee.[Last Name] IN (@Pm_Employee_Last_Name) And Employee.[First Name] IN (@Pm_Employee_First_Name)

ORDER BY Orders.[Order Date]