Send Excel Files every Month to different supervisors with restricted view

[kkirnbauer]

Hi,

if created a native SQL Statement in Report Studio, which gives me information on employees about holidays, ....

In the Report every Supervisor can only see his employees. I've used the session parameter as filter criteria (#sq($account.personalInfo.givenName)#)

Now there should be a monthly scheduled task, which send this report via mail as Excel File to the supervisors. Is there any chance to do that?

Thanks

Kind Regards

[hespora]

Not like that. If you setup the schedule centrally, it will be executed with your user account rather than the ones you setup that filter for.

What you want is to create a view for each user and have them schedule those themselves, so they are executed with their own user. Otherwise, just ditch the dynamic filter and hardcode it.