****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Parameter Fields.rdl
****************************************************************************************************

-------------------------------------------------- Datasets --------------------------------------------------

-- Query(s)


SELECT Customer.[Customer Name], Customer.Region, Orders.[Order ID], Orders.[Order Amount], Orders.[Order Date], Customer.Country 
FROM   Xtreme2005DB.dbo.Customer Customer LEFT OUTER JOIN Xtreme2005DB.dbo.Orders Orders ON Customer.[Customer ID]=Orders.[Customer ID]  
WHERE (Customer.[Customer Name] like @Customer_Name) And Customer.Region IN (@Region) And (Orders.[Order Date] >= @Date_RangeStart And Orders.[Order Date] <= @Date_RangeEnd) 
 
ORDER BY Customer.Region