Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: crystal report must prompt for password Post Reply Post New Topic
Author Message
jyoths.cupid
Newbie
Newbie


Joined: 01 Sep 2010
Location: India
Online Status: Offline
Posts: 5
Quote jyoths.cupid Replybullet Topic: crystal report must prompt for password
    Posted: 01 Sep 2010 at 10:09pm
I want my crystal report to be prompted for password when a user runs it.
 
Currently my connection settings are as below.
Data Source name: ORA_ABCDEFG
USER ID: ABCDEFG/password1
So now when I invoke crystal report it is using the password mentioned in userid filed after the slash(/).
 
But I dont want to have my password in the crystal report. and also I could not pass it from the code at runtime.
 
I just wanted to run my crystal reports with password prompt. Since this is an internal application, I will distribute the password to my internal users. so that when crystal report prompt for password they can enter the distributed passord
 
Please advise.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Sep 2010 at 11:13am
How are you distributing this report?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
jyoths.cupid
Newbie
Newbie


Joined: 01 Sep 2010
Location: India
Online Status: Offline
Posts: 5
Quote jyoths.cupid Replybullet Posted: 06 Sep 2010 at 12:18am
An application developed in Delphi invokes this crystal reports. Where we do not have any control on the source code. (a 3rd party vendor has developed it.)
So whatever we can do is with in the crystal report alone.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 06 Sep 2010 at 11:35am
Have you tried taking the /password off the end of the user ID?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
jyoths.cupid
Newbie
Newbie


Joined: 01 Sep 2010
Location: India
Online Status: Offline
Posts: 5
Quote jyoths.cupid Replybullet Posted: 07 Sep 2010 at 11:58pm
Yes, I have tried but it gave me incorrect login parameters error.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 08 Sep 2010 at 5:07am
What type of connection are you using?  Native Oracle?  ODBC?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Sep 2010 at 5:19am
Since this is a Delphi internal app, Delphi controls passing the user id/pw to Crystal Reports via the api. If you have no control over the source code, then I don't see how you can change anything at all b/c that is what controls the credentials. Plus, how is Delphi getting the credentials anyway? Is there a dialog box that pops up, or is it in a config file on the local computer?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
jyoths.cupid
Newbie
Newbie


Joined: 01 Sep 2010
Location: India
Online Status: Offline
Posts: 5
Quote jyoths.cupid Replybullet Posted: 08 Sep 2010 at 7:42pm

Iam using ODBC DSN.

And my delphi application is not sending any userid/password to crystal report for sure. If I remove the password from the crystal report data source it is throwing incorrect login parameters error.
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 09 Sep 2010 at 3:20am
Is there any chance that you can modify the report to use a Native Oracle connection instead of ODBC?  You might have to do some work in the app to get it to handle that - I'm not sure though and it has been over 10 years since I've worked with the Crystal component for Delphi.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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.