Can we contol the privilege of Drilling down

How can we contol 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 reoprt of whole company,
and view the individual sales report of the four area. The sales can view
the total sale reoprt of whole company, but the can only drill down the area
of themself, they can not drill down the other area .
How can I do that?Can any one help me!
"ad" <ad@.wfes.tcc.edu.tw> ¼¶¼g©ó¶l¥ó·s»D
:O3OBudyXFHA.3040@.TK2MSFTNGP14.phx.gbl...
> How can we contol 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 reoprt of whole
company,
> and view the individual sales report of the four area. The sales can view
> the total sale reoprt of whole company, but the can only drill down the
area
> of themself, they can not drill down the other area .
> How can I do that?
>sql