access via parameter

[nat35]

hi there
I have a report based on sp and i have parm company id.
How can i give access only to the individual companies that only need access to their states.
thank you

 

[IdoMillet]

Please explain in more detail.

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[nat35]

okay
I have a report is published with Citrix program where all state's users can see this report(who has a access).
The report has a parm let say state.the report base on sp
from sql2000.At the moment if you run report you can choose the state and run.I want if the user from state1
he is able to run the report agains only state1.
nat

 

[IdoMillet]

AFAIK, this type of user-based row-level security is only available via 3rd-party tools (see a list at:

http://www.kenhamady.com/bookmarks.html)

and through "processing extensions" in Crystal Enterprise.

In the case of my DataLink Viewer, you create a String parameter named "DLV_User_ID".
DataLink Viewer automatically sets the value of such a parameter to the User ID who is logged in to the PC.
You then specify a record selection criterion that restricts the data according to this parameter.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com