Start New Discussion within our Software Development Community

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

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!

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

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

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

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?

Comments
do you realise this thread is almsot 3 years old.

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.

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.

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

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

This article has been dead for over six months. Start a new discussion instead.