Tuesday, February 14, 2012

Can not we do that?

I have place the question for a while, but there are no answer untill now?
Can not we do that?, I am anxious about that!
----
---
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?You might try adding the drilldown as a subreport, and pass the USer! name
value , then either filter or dynamic query for the details by joining with
the user name information...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:ekmZg99XFHA.1240@.TK2MSFTNGP14.phx.gbl...
>I have place the question for a while, but there are no answer untill now?
> Can not we do that?, I am anxious about that!
> ----
> ---
> 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?
>|||AFAIK there is no built in functionality, but you could do that with
disabling the visibility for the clickthough item and enabling the
visibility for the non-clickable item based on a dataset which display the
actal permission set of the user.
If your report is based on SQL Server you could us a view or query which
uses the CURRENT_USER function to check which user is authenticated and pass
the appopiate permissions (se) to the report.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"ad" <ad@.wfes.tcc.edu.tw> schrieb im Newsbeitrag
news:ekmZg99XFHA.1240@.TK2MSFTNGP14.phx.gbl...
>I have place the question for a while, but there are no answer untill now?
> Can not we do that?, I am anxious about that!
> ----
> ---
> 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?
>

No comments:

Post a Comment