Create Parameters On SSRS for Query Data (Advance) #3

http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-for-share-point.html
http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-publish-on-share.html

We are moving to SSRS in advance, Now it's time to create some parameters to selection from database as we wanted. Let's go to step by step

For this concept, we will select Year and Property from database as we have on hand to be a selection when we wanted to run report.

STEP-1
Query data for value to create drop down on parameters, Click right on "Datasets" on Report Data area, if your could not see this area, go to "View" menu on top then select "Report Data" as below

STEP-2
Select Data Set from data source in same report

STEP-3Query data form table to get year value

Example Query for Year Parameter
SELECT distinct (year) FROM customer ORDER BY year DESC

STEP-4 

Now you will see Data Year as image below. Next step is create parameters by click right on "Parameters" menu

STEP-5 parameter name and label, select data type as "Allow multiple values" and "Allow blank value ("")"

Set



STEP-6 
Set value for Year parameter by click on "Available Values" then
Select from one of the following options : Get values from a query
Dataset: "dataset name" select dataset as we created
Value field: "Field year name"
Label field: "Field year name"

STEP-7
After finished create parameter "Year" you have to set parameter on your query as
"SELECT * FROM TABLE WHERE (pl_year in (@Year))"

STEP-8
Every thing have done now, you have to preview and select parameter as image