Search code examples
sql-server-2008drop-down-menuparametersssrs-2008sql-delete

Updating drop down list values in SSRS Parameter

I have a problem in my report, the parameter for Students need to be updated as they have left.

At present it shows all list of students(Multi-Value) and picking them along with other parameters will show data in report.

My question is should I delete the students from database itself or can I restrict them in report parameter so it shows only current enrolled students.

Thanks, AR

Solution

  • Delete Students is not the Ideal way in terms of maintain Historical data.

    You can update the Active status in database for those Students have left. And return the Students whose status is Active in the result set of the SSRS report.

    Please find more help here.