Last post Dec 15, 2017 09:52 AM by Omkar Mhaiskar
Dec 15, 2017 09:42 AM|JagjitSingh|LINK
In a parameter i want to display Years from 2002 to till current Year
Dec 15, 2017 09:52 AM|Omkar Mhaiskar|LINK
Right click the parameter under the "Report Data" and select "Parameter Properties"
Select "Available Values" section
Click the "Get values from a query" option
4a. Select the appropriate query to use make sql for getting year data.
with yearlist as
select 2004 as year
select yl.year + 1 as year
from yearlist yl
where yl.year + 1 <= YEAR(GetDate())
select year from yearlist order by year desc;
Or Use stored procedure to get values.
4b. Select the Value that you want the main query to use to generate the data
4c. Select the Label that will show in the drop down box that the User sees and selects a option from