CrystalReportViewer

[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

[Bernie Yaeger]

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

[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

[Richard]

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

[tg]

Thanks Richard. Fits the bill...

"Richard" <[e-mail]> 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