• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • Last Modified:

How to pass the database username and password in Crystal Reports/Crystal Enterprise 10?


I have created several reports using crystal reports 10 and SQL Server for the data source.  The reports are being deployed using Crystal Enterprise.

I have created a DSN to the SQL Server database on both my local PC and on the Crystal Enterprise server.   When setting up the DSN, we selected the authentication option for “With SQL Server authentication using a login ID and password entered by the user".   A standard user name "crystal" was created in the database on the SQL Server.

To publish report I used the Crystal publishing wizard.  After publishing the report I try to run it via Crystal Enterprise and upon running, a dialog box is displayed requesting a username and password.  Is there any way to pass the username and password information (either in the report or on the Crystal Enterprise server) so that the user is not presented with the login dialog box?

In the past, we utilized Crystal Report Application Server (RAS) to deploy the reports and we modified by adding the following code to clientDoc.databaseController.logon "<your user name>", "<your password>"  the interactiveViewer.asp,   pageViewer.asp and partsViewer.asp files to passed the username and password.
0
PhilChandler
Asked:
PhilChandler
  • 2
  • 2
1 Solution
 
mlmccCommented:
What other options do you have instead of
“With SQL Server authentication using a login ID and password entered by the user"

mlmcc
0
 
frodomanCommented:
You'll need to login to Crystal Enterprise Management Console and browse to the specific report (using the 'Manage Objects' will be the easiest method).  There will be a "Database" tab for the report that allows you to set the connection options - here you'll want to enter the credentials to be used and insure the checkbox for "Prompt the user for database logon when viewing
" is NOT checked.  Don't forget to click the "Update" button after you've entered them and then you can preview the report from Crystal Enterprise to insure you aren't prompted.

HTH

frodoman
0
 
PhilChandlerAuthor Commented:
Can I call a CE report from an application (e.g. Coldfusion) using a URL?  If so, how do I structure the URL link?
0
 
PhilChandlerAuthor Commented:
The information from frodoman worked.  It wasn't actually a "tab" for Database, but a link in the Process tab.  This worked once we added the database information.  Thanks so much.  I will post my other question listed above as a separate question..
0
 
frodomanCommented:
Glad to help.  I'll watch for your next question...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now