Row-level security in crystal

[nat35]

Hi there,
how to set up Row-level security . When a user runs a Crystal Report, that report will only include information that is appropriate for that user.
thank you
nat

 

[synapsevampire]

Do so on the database side based on the connection, that generally isn't part of a tool connecting to the database, and it's dependent upon the database.

An alternative might be to exclude rows based on some field value in the record selection formula (Report->Edit Selection Formula->Record), as in:

{table.field} = "Employee 1 data"

-k

 

[IdoMillet]

As an alternative, have a look at the listing of 3rd-party Viewers & Tools mainatined by Ken Hamady at:

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

Some of these tools provide user-based data restrictions.

In the case of my DataLink Viewer, it can automatically set a report parameter to the user_id who is logged in to the PC. You then design your report to restrict the info shown to that user by creating a record selection criterion that depends on the value in that parameter.

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[nat35]

Hi there
thank you for tips
Basicly my report has been published on Citrix Metaframe
and has a link to sql2000 stored procedure via obdc.
My question is it is any way to pass userid and password
to crystal then to database via odbc or still need to use third part.or another question is how to stick to sql2000
userid and password.
sorry my head is absolutly massy.I dont know what to start with
Thak you Nat

 

[IdoMillet]

I'm not sure I understand the question.
Can you clarify?

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[nat35]

okay i'll try again(sorry english is my second )
I have a crystal report and i have a stored procedure with parameter stateID in sql2000. So I am using ODBC connection.
The report has been compiled and published on Citrix MetaFrame and give access to users .Once the run they
have a paramer stateID(VIC,QLD,NSW).At the moment even the
user is from vic he can still choose QLD and run a report .
I want if it is VIC user he will see data in the report
only for VIC.So where can I check who is running report,
Yes,I can publish 3 reports and give access for each state but if i can work out with this security problem would be nice.
thank you to be patient and try to understand me.

nat

 

[IdoMillet]

I'm not aware of any way to achieve what you are looking for just with Crystal's built-in functionality.

The 3 report option sounds simple and effective. It will even let you get rid of the parameter...

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[nat35]

thank you.But I still want to know if any ways to do it.
Let say to use third pard app or publish on web or create a form in Access2000.
I have crystal 8 and crystal 7.
if you have an idea or you know any websites for beginners.
I would appreciate