943,920 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 11631
  • VB.NET RSS
Nov 7th, 2008
0

Crystal Reports asks for Username and Password while loading

Expand Post »
Hi,

My Crystal Report is using VB.NET and Sql server 2005.
The report can be displayed but everytime it will prompt me to key in the Username n Password..


is there anyway to automatically pass the login information to reports?

thanks
=)
Last edited by potatochips; Nov 7th, 2008 at 4:45 am.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
potatochips is offline Offline
15 posts
since Jul 2007
Nov 7th, 2008
0

Re: Crystal Reports asks for Username and Password while loading

An idea but not necessarily the best,

you could write it to the registry.
Featured Poster
Reputation Points: 1536
Solved Threads: 431
Posting Expert
iamthwee is offline Offline
5,865 posts
since Aug 2005
Nov 7th, 2008
0

Re: Crystal Reports asks for Username and Password while loading

hi
thanks for your reply, but could u guide me to how to achieve that?
=D
cos im kinda new to all this
=/

thanks lots!
Reputation Points: 10
Solved Threads: 0
Newbie Poster
potatochips is offline Offline
15 posts
since Jul 2007
Nov 10th, 2008
0

Re: Crystal Reports asks for Username and Password while loading

ok i solved the problem myself..
i shall paste the code here if somebody met the same problem as me..
=)

just need a simple code :

VB.NET Syntax (Toggle Plain Text)
  1. report.SetDatabaseLogon(user, pwd)

u need to declare the "report" and the user, pwd before this line of code..
=D
Reputation Points: 10
Solved Threads: 0
Newbie Poster
potatochips is offline Offline
15 posts
since Jul 2007
Nov 10th, 2008
0

Re: Crystal Reports asks for Username and Password while loading

You can pass login parameter to crystal reports dyanmically .

http://vb.net-informations.com/cryst...ynamically.htm

bruce.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bruce2424 is offline Offline
23 posts
since Jun 2008
Dec 18th, 2009
0

Having trouble with Crystal Report wanting password

Hi have tried this but no luck can anybody help with this

ok i solved the problem myself..
i shall paste the code here if somebody met the same problem as me..
=)

just need a simple code :

VB.NET Syntax (Toggle Plain Text)
  1. report.SetDatabaseLogon(user, pwd)

u need to declare the "report" and the user, pwd before this line of code..
=D
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ChrisDubai is offline Offline
1 posts
since Dec 2009
May 25th, 2011
0
Re: Crystal Reports asks for Username and Password while loading
Thanks potatochips
command " report.SetDatabaseLogon(user, pwd)"
works for me.
Thanks & regards.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
sirfan_2002 is offline Offline
1 posts
since May 2011
Jul 19th, 2011
-1
Re: Crystal Reports asks for Username and Password while loading
report.SetDatabaseLogon(user, pwd)report.SetDatabaseLogon(user, pwd)

u need to declare the "report" and the user, pwd before this line of code..

what does the dim statment look like?
Reputation Points: 7
Solved Threads: 0
Newbie Poster
longstrd is offline Offline
5 posts
since Jun 2011
Sep 8th, 2011
0
Re: Crystal Reports asks for Username and Password while loading
i a encountering this problem too
in my ms access databse in vb.net


I used report.SetDatabaseLogon(user, pwd)
but i dont know what to set in my user and pwd because i didnt set a username and password.

i declare report as
Dim report As New ReportDocument
is that correct?
help me.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Polongo is offline Offline
13 posts
since Dec 2010
Sep 8th, 2011
0
Re: Crystal Reports asks for Username and Password while loading
I am not sure how this occured, I did not reply to this thread.
I use the report viewer and I feed the report parameters. I am building a web page that will have a dynamic menu and dynamic report viewer.
I gave up on attempting to send a user's credentials from the IIS server hosting a web page to the Report server. ( try that one on the fourm world. so many items where a person says Dynamic and people answer with a static solution or the one where someone suggests using Bacis Auth. no! )
However I realized all I needed to do was pass the user id to the report parameters and that works fine.
I do not need to log on to the data base, since that issue is taken care on the Report Server side.
I hope you resolve your issue.
P.S. I still use Crystal reports for Incident reporting. Crystal is used by Heat ( FrontRange ) and LanDesk.
Reputation Points: 7
Solved Threads: 0
Newbie Poster
longstrd is offline Offline
5 posts
since Jun 2011

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: There is no Row at Position 0... sometimes
Next Thread in VB.NET Forum Timeline: Relative Links in VB Files





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC