Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: ODBC connection prompt in Crystal server Post Reply Post New Topic
Author Message
joecarde
Newbie
Newbie


Joined: 15 Jul 2008
Location: United States
Online Status: Offline
Posts: 6
Quote joecarde Replybullet Topic: ODBC connection prompt in Crystal server
    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
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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


Edited by rahulwalawalkar - 20 Aug 2008 at 3:17am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.