We have a situation in that there are more than 40 Dept’s in the Ledger data, with a number of Managers.
The Managers need to report on just the Dept’s that they manage, which might be anywhere from 1-6 different Depts.

We have various Statements that we want to run by Department, or by a Department Group (consolidating a few Dept’s into one Group).

Currently, we are saving the Statements in files that are available to all the Mgrs.

Question: Is it possible to limit the Statement by Manager, such that each user will only be able to run the Statement by those Dept’s that they manage?
We would like to filter out all the other Dept’s that each Mgr is not responsible for.