Crystal Reports asks for Username and Password while loading

[potatochips]

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
=)

[iamthwee]

An idea but not necessarily the best,

you could write it to the registry.

[potatochips]

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!

[potatochips]

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 :

report.SetDatabaseLogon(user, pwd)

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

[bruce2424]

You can pass login parameter to crystal reports dyanmically .

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_load_dynamically.htm

bruce.

[ChrisDubai]

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 :

report.SetDatabaseLogon(user, pwd)

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

[sirfan_2002]

Thanks potatochips
command " report.SetDatabaseLogon(user, pwd)"
works for me.
Thanks & regards.

[longstrd]

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?

[Polongo]

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.

[longstrd]

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.

[S.L.KEER]

try that open field explorer---> database field --->Right Click -->current Data source --->reports connection----->report ----->property ----> set Property as---

Data Source: .\Databasename.accdb

and code on viewer form load as

Dim cryRpt As New ReportDocument

Dim Report1 As New rptItemWise

Dim strServerName As String
strServerName = Application.StartupPath

rptItemWise.SetDatabaseLogon("admin", "", strServerName, "dastabasename.accdb", True)

cryRpt.Load(Application.StartupPath + "\rptItemWise.rpt")

also change the report connection same as data source i think that code work for you ....

[sushan.kadu]

hi friends just to project -right click--on project property---change .netframework4.5 to .netframework 3.5

[Melvin_2]

Visual FoxPro d/b. Same issue.
I get this issue connecting to Visual FoxPro database from a ClickOnce Crystal Report App.
I just can't populate the Report as I have no idea what the UserID and Password for .DCT database
So I can't Parse the parameters in c# code as that is what I am using in Visual Studio 2012.

Wordy
9 Oct 2016