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

-------------------------------------------------- Main Body --------------------------------------------------


SELECT 
	Customer.[Customer ID]
	,Customer.[Customer Name]
	,Customer.Region
	,Customer.Country
	,Orders.[Order ID]
	,Orders.[Order Amount]
	,Orders.[Customer ID]
	,Orders.[Order Date]
FROM
	Xtreme2005DB.dbo.Customer
		LEFT OUTER JOIN Xtreme2005DB.dbo.Orders ON Xtreme2005DB.dbo.Customer.[Customer ID] = Xtreme2005DB.dbo.Orders.[Customer ID]
WHERE
	Customer.[Customer Name] like {?Customer Name} and
Customer.Region = {?Region} and
Orders.[Order Date] = {?Date Range}
ORDER BY
	[@Group By] ASC -- Group #1
	,Customer.Region ASC