sql server 2008 - Updating drop down list values in SSRS Parameter -

i have problem in report, parameter students need updated have left.

at present shows list of students(multi-value) , picking them along other parameters show data in report.

my question should delete students database or can restrict them in report parameter shows current enrolled students.

thanks, ar

delete students not ideal way in terms of maintain historical data.

you can update active status in database students have left. , return students status active in result set of ssrs report.

please find more here.