Can we control the privilege of Drilling down?

How can we control the privilege of Drilling down?

For example:

There are for sale area of a company.

The manager of the company can view the total sale report of whole company, and view the individual sales report of the four area. The sales can view the total sale report of whole company, but they can only drill down the area of himself,they can not drill down the other area .

How can I do that?

Hi,
you can perform check of privilege of drilling down by Code in (ReportProperties).
For example (in Properties):
[Row].Visibility = Code.MyFunction
where MyFunction check if the Current user has necessary privilege to see selected row.

Best Regards