Print Page | Close Window

ODBC connection prompt in Crystal server

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3890
Printed Date: 03 May 2024 at 3:57pm


Topic: ODBC connection prompt in Crystal server
Posted By: joecarde
Subject: ODBC connection prompt in Crystal server
Date Posted: 04 Aug 2008 at 3:13pm
Hello --

I am using CR XI and I have an ODBC connection to an AR System database (Remedy).

I've set the system DSN on the crystal server, and it remembers the username & password.

Whenever I run my imported Remedy reports, I'm always asked for the login credentials before it will run.

Is there a way to force the report to use the DSN login creds, and thus not have my users have to enter them?

Thanks in advance,
JC


Replies:
Posted By: rahulwalawalkar
Date Posted: 20 Aug 2008 at 3:17am
Hi,
 
Go to the report in Crystal Server then Select the report then Select Process Tab,then Select Database Tab the scroll down
 
and select this option in When Viewing report
 
Use same database logon as when report is run
 
Then click update
 
Cheers
Rahul


Print Page | Close Window