Skip to Content
0

Is it possible to imbed logon information into a sub report?

Feb 20 at 04:49 PM

16

avatar image
Former Member

I am writing a report that uses a sub report to get information from a different DSN. Each time the report is run the user is prompted to enter a user name and password. I am wondering if it is possible to imbed the logon information into the sub report to avoid this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vitaly Izmaylov
Feb 20 at 04:51 PM
0

For security reasons Crystal Reports files (.rpt) do not store DB credentials.

There is unsecure option to use ODBC Connection string, but you should understand the security risk to store access to database in a file.

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Feb 20 at 04:52 PM
0

Hi Chris,

Which database are you reporting against?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
Feb 21 at 07:27 PM
0

If your DB supports NT Authentication then check on the option to use that when making the connection to the subreport.

That way it won't prompt the user to log on.

Don

Share
10 |10000 characters needed characters left characters exceeded