Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Password to Access Crystal reports
- Thread starter dreman
- Start date
synapsevampire
Programmer
It sounds like you want a report to allow access to other reports, or perhaps itself based on a user/password.
In either case, Crystal doesn't really do this. You need another layer to supply security. A common codeless one is the Standard version of Crystal Enterprise, which comes free with Crystal Reports Pro and Dev.
It won't let you leverage security based on user/password lookup in a table readily, for that, you'll need to code.
-k kai@informeddatadecisions.com
In either case, Crystal doesn't really do this. You need another layer to supply security. A common codeless one is the Standard version of Crystal Enterprise, which comes free with Crystal Reports Pro and Dev.
It won't let you leverage security based on user/password lookup in a table readily, for that, you'll need to code.
-k kai@informeddatadecisions.com
- Thread starter
- #4
Yes I know that with Crystal report enterprise. But the problem it is very limited unless you purchase enterprise pro which is very expensive (about 20 K and up).
I am trying to see another way. like stored procedure or a utilty based on the login. Any thought are helpful.
Thanks.
dré
I am trying to see another way. like stored procedure or a utilty based on the login. Any thought are helpful.
Thanks.
dré
synapsevampire
Programmer
You can write a VB app to launch reports, and base your security on user/pw from a table, if that's the key element here.
I think that apos (crystal partner) has an alternative to CE, but it isn't cheap.
Check kenhamady.com for a good starting point for source, he charges $14.
Another alternative might be to use NT Authentication on the DSN, then the report would only run for those that are allowed to hit the DB. I've never done this, but it seems reasonable.
-k kai@informeddatadecisions.com
I think that apos (crystal partner) has an alternative to CE, but it isn't cheap.
Check kenhamady.com for a good starting point for source, he charges $14.
Another alternative might be to use NT Authentication on the DSN, then the report would only run for those that are allowed to hit the DB. I've never done this, but it seems reasonable.
-k kai@informeddatadecisions.com
- Thread starter
- #6
synapsevampire
Programmer
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question