Link to home
Create AccountLog in
Avatar of henry
henry Flag for United States of America

asked on

save user and password in crystal report

Hello,
How can I save connection parameters in crystal report ver XI ?
I have to run reports automatically and I need save parameters when crystal ask about user and password when connecting to database. How can I do that ?
thx
henry
ASKER CERTIFIED SOLUTION
Avatar of ast2550
ast2550

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Out of interest, if you use an ODBC datasource for Crystal, you can supply a Connection String which can include the username and password.

Obviously, this is visible to anyone opening the report in Crystal (or using COM tools to read the report).

If you can create a read-only account on the database which is limited to the specific tables/views/procedures/etc. needed for the report, then you may find this a suitable alternative to maintaining security credentials elsewhere.