By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,478 Members | 1,833 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,478 IT Pros & Developers. It's quick & easy.

CrystalReportViewer

P: n/a
tg
My sincere apologies for the crosspost. I posted in one other ng. I am not
sure which is the correct ng for this question.I'm using .NET 2003. This is
the first time I've tried to use Crystal
within .NET. I'm connecting to an Oracle database. I'm using
System.Data.OracleClient, dll v1.1.4322. I can connect to the server
with no problem through the report. I place a Windows
CrystalReportViewer on a form, but when I run the form, I cannot
connect to the server. I am presented with a dialog box asking for
server name, user name, etc., but it gives me a dialog box stating it
cannot log on to server, after I enter the credentials.

I have the connection string set in the OracleConnection, and the
ReportSource is set on the CrystalReportViewer.

Can someone please offer help?

Many thanks
tjguillo
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi tjguillo,

Go to the report's database menu, set database location, properties. You
need to define the login elements inside the report, or you need to do it in
a report document object.

HTH,

Bernie Yaeger

"tg" <tg*******@pop-server.houston.rr.com> wrote in message
news:k0*******************@fe2.texas.rr.com...
My sincere apologies for the crosspost. I posted in one other ng. I am
not sure which is the correct ng for this question.I'm using .NET 2003.
This is the first time I've tried to use Crystal
within .NET. I'm connecting to an Oracle database. I'm using
System.Data.OracleClient, dll v1.1.4322. I can connect to the server
with no problem through the report. I place a Windows
CrystalReportViewer on a form, but when I run the form, I cannot
connect to the server. I am presented with a dialog box asking for
server name, user name, etc., but it gives me a dialog box stating it
cannot log on to server, after I enter the credentials.

I have the connection string set in the OracleConnection, and the
ReportSource is set on the CrystalReportViewer.

Can someone please offer help?

Many thanks
tjguillo

Nov 21 '05 #2

P: n/a
tg
Bernie -

I followed your suggestion. I get the same result.

tjguillo

"Bernie Yaeger" <be*****@cherwellinc.com> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
Hi tjguillo,

Go to the report's database menu, set database location, properties. You
need to define the login elements inside the report, or you need to do it
in a report document object.

HTH,

Bernie Yaeger

"tg" <tg*******@pop-server.houston.rr.com> wrote in message
news:k0*******************@fe2.texas.rr.com...
My sincere apologies for the crosspost. I posted in one other ng. I am
not sure which is the correct ng for this question.I'm using .NET 2003.
This is the first time I've tried to use Crystal
within .NET. I'm connecting to an Oracle database. I'm using
System.Data.OracleClient, dll v1.1.4322. I can connect to the server
with no problem through the report. I place a Windows
CrystalReportViewer on a form, but when I run the form, I cannot
connect to the server. I am presented with a dialog box asking for
server name, user name, etc., but it gives me a dialog box stating it
cannot log on to server, after I enter the credentials.

I have the connection string set in the OracleConnection, and the
ReportSource is set on the CrystalReportViewer.

Can someone please offer help?

Many thanks
tjguillo


Nov 21 '05 #3

P: n/a
Dim oRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocum ent
oRpt.Load("c:\reportname.rpt")

Dim logonInfo As New CrystalDecisions.Shared.TableLogOnInfo()
Dim table As Table

' Set the logon information for each table.
For Each table In oRpt.Database.Tables
' Get the TableLogOnInfo object.
logonInfo = table.LogOnInfo
' Set the server or ODBC data source name, database name,
' user ID, and password.
logonInfo.ConnectionInfo.ServerName = "servername"
logonInfo.ConnectionInfo.DatabaseName = "databasename"
logonInfo.ConnectionInfo.UserID = "userid"
logonInfo.ConnectionInfo.Password = "password"
' Apply the connection information to the table.
table.ApplyLogOnInfo(logonInfo)
Next table

CrystalReportViewer1.ReportSource = oRpt

GK

"tg" <tg*******@pop-server.houston.rr.com> wrote in message
news:k0*******************@fe2.texas.rr.com...
My sincere apologies for the crosspost. I posted in one other ng. I am
not sure which is the correct ng for this question.I'm using .NET 2003.
This is the first time I've tried to use Crystal
within .NET. I'm connecting to an Oracle database. I'm using
System.Data.OracleClient, dll v1.1.4322. I can connect to the server
with no problem through the report. I place a Windows
CrystalReportViewer on a form, but when I run the form, I cannot
connect to the server. I am presented with a dialog box asking for
server name, user name, etc., but it gives me a dialog box stating it
cannot log on to server, after I enter the credentials.

I have the connection string set in the OracleConnection, and the
ReportSource is set on the CrystalReportViewer.

Can someone please offer help?

Many thanks
tjguillo

Nov 21 '05 #4

P: n/a
tg
Thanks Richard. Fits the bill...

"Richard" <kg@nospam.com> wrote in message
news:eM*************@TK2MSFTNGP14.phx.gbl...
Dim oRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocum ent
oRpt.Load("c:\reportname.rpt")

Dim logonInfo As New CrystalDecisions.Shared.TableLogOnInfo()
Dim table As Table

' Set the logon information for each table.
For Each table In oRpt.Database.Tables
' Get the TableLogOnInfo object.
logonInfo = table.LogOnInfo
' Set the server or ODBC data source name, database name,
' user ID, and password.
logonInfo.ConnectionInfo.ServerName = "servername"
logonInfo.ConnectionInfo.DatabaseName = "databasename"
logonInfo.ConnectionInfo.UserID = "userid"
logonInfo.ConnectionInfo.Password = "password"
' Apply the connection information to the table.
table.ApplyLogOnInfo(logonInfo)
Next table

CrystalReportViewer1.ReportSource = oRpt

GK

"tg" <tg*******@pop-server.houston.rr.com> wrote in message
news:k0*******************@fe2.texas.rr.com...
My sincere apologies for the crosspost. I posted in one other ng. I am
not sure which is the correct ng for this question.I'm using .NET 2003.
This is the first time I've tried to use Crystal
within .NET. I'm connecting to an Oracle database. I'm using
System.Data.OracleClient, dll v1.1.4322. I can connect to the server
with no problem through the report. I place a Windows
CrystalReportViewer on a form, but when I run the form, I cannot
connect to the server. I am presented with a dialog box asking for
server name, user name, etc., but it gives me a dialog box stating it
cannot log on to server, after I enter the credentials.

I have the connection string set in the OracleConnection, and the
ReportSource is set on the CrystalReportViewer.

Can someone please offer help?

Many thanks
tjguillo


Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.