If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Send Excel Files every Month to different supervisors with restricted view  (Read 1916 times)


  • Guest

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?


Kind Regards

Offline hespora

  • Statesman
  • ******
  • Join Date: Nov 2015
  • Posts: 394
  • Forum Citizenship: +23/-0
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.