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

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