Member Avatar

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

Member Avatar

An idea but not necessarily the best,

you could write it to the registry.

Member Avatar

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!

Member Avatar

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

Member Avatar

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

Member Avatar

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

Member Avatar

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?

commented: do you realise this thread is almsot 3 years old. -3
Member Avatar

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.

Member Avatar

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.

Member Avatar

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 ....

Member Avatar

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

Member Avatar

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

Edited by Melvin_2