Let's Say I want to show students name based on selected School Name. So I created a parameter called SchholName and using drop down to show all school name at the time me executing report. Also I am using View to retreive data from SQL server. But filter is not working it shows students name from all school. Do I need to give Where clause in my view, but how will I pass that parameter to SQL?

Please help me.