Don't think ssrs will filter data for you. You can create sp for the report and pass department as parameter, each department will get its data only based on parameter.