SSRS Report paramter for sql query

 Generate SSRS Report based on user inputs done with the help of Parameters.

T-SQL Query:

SELECT   DimSalesTerritory.SalesTerritoryRegion, DimDate.CalendarYear, SUM(FactResellerSales.SalesAmount) AS SalesAmount, SUM(FactResellerSales.TaxAmt) AS TaxAmount, DimDate.CalendarQuarter,

                         DimDate.EnglishMonthName

FROM            FactResellerSales 

INNER JOIN      DimSalesTerritory ON 

FactResellerSales.SalesTerritoryKey = DimSalesTerritory.SalesTerritoryKey 

INNER JOIN      DimDate ON DimDate.DateKey = FactResellerSales.DueDateKey

WHERE  (DimDate.CalendarYear = @Year)

GROUP BY DimSalesTerritory.SalesTerritoryRegion, DimDate.CalendarYear, DimDate.CalendarQuarter, DimDate.EnglishMonthName

@Year is parameter for this DataSet Query.

Now Prepare a Dataset.

now we added parameter information. as a enduser don't know avaialble years of database  so execute db query based it add years as Lables

now perview no data beacuse no defult value of @Year parameter

Through this demonstration we will know it as Text query also(without stored procedure) we can pass parameter to query.  

Parameter (@Year) is passed for sql Query.