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

 

Send Excel Files every Month to different supervisors with restricted view

Started by kkirnbauer, 25 Oct 2016 01:01:04 AM

Previous topic - Next topic

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.