Crystal Reports 10 - How to set Server and DataBase At runtime.

[runningdog]

Hi,

I'm trying to set the servername and database for an untyped report at
runtime.
It seems I should do something like the following.

Dim Table As Table
Dim LogonInfo As New TableLogOnInfo
For Each Table In reportDocument. Database.Tables
LogonInfo = Table.LogOnInfo
LogonInfo.Conne ctionInfo.Serve rName = ConnectString.D ataSource
LogonInfo.Conne ctionInfo.Datab aseName = ConnectString.I nitialCatalog
Table.ApplyLogO nInfo(LogonInfo )
Next

However I get the following error:
:Value of type 'CrystalDecisio ns.Shared.Table LogOnInfo' cannot be converted
to 'CrystalDecisio ns.Shared.Table LogOnInfo'.

Can someone point me in the right direction?
TIA Steve

[Peter Huang]

Hi Steve,

I think you may take a look at the link below and try to run the steps in
the links to see if the problem persists.
Crystal Report 8.5 for Visual Studio.NET (using C#)
http://www.dotnetforce.com/(kfofub55...aspx?t=a&n=179

When did the problem occur in the runtime or the compile time?

Also which code line pop up the error message, is the line below?
Table.ApplyLogO nInfo(LogonInfo )

I think you may try to change your code as below to see if the problem
persists, becauses the VB.NET is case-insensitive language.
Dim tbl As Table
Dim logInfo As New TableLogOnInfo
For Each Table In reportDocument. Database.Tables
logInfo = tbl.LogOnInfo
logInfo.Connect ionInfo.ServerN ame = ConnectString.D ataSource
logInfo.Connect ionInfo.Databas eName = ConnectString.I nitialCatalog
tbl.ApplyLogOnI nfo(LogonInfo)
Next

Also can you check if you are using the same version of crystal reporter
assembly, i.e. if the CrystalDecision s.CrystalReport s.Engine.dll is for
.net framework 1.1 and CrystalDecision s.Shared.dll is for .net frameword
1.0 which may cause the problem.

Here is the setting on my machine, you may check them in the object browser
by pressing Ctrl+Alt+J
Assembly CrystalDecision s.Shared
C:\Program Files\Common Files\Crystal
Decisions\1.1\M anaged\CrystalD ecisions.Shared .dll
Assembly CrystalDecision s.CrystalReport s.Engine
C:\Program Files\Common Files\Crystal
Decisions\1.1\M anaged\CrystalD ecisions.Crysta lReports.Engine .dll

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

[runningdog]

Thanks for a very thoughtful responce Peter.
I'll have a look on Monday and get back to you.

Regards Steve

""Peter Huang"" <v-******@online.m icrosoft.com> wrote in message
news:zP******** ******@cpmsftng xa10.phx.gbl...

Hi Steve,

I think you may take a look at the link below and try to run the steps in
the links to see if the problem persists.
Crystal Report 8.5 for Visual Studio.NET (using C#)
http://www.dotnetforce.com/(kfofub55...aspx?t=a&n=179
When did the problem occur in the runtime or the compile time?

Also which code line pop up the error message, is the line below?
Table.ApplyLogO nInfo(LogonInfo )

I think you may try to change your code as below to see if the problem
persists, becauses the VB.NET is case-insensitive language.
Dim tbl As Table
Dim logInfo As New TableLogOnInfo
For Each Table In reportDocument. Database.Tables
logInfo = tbl.LogOnInfo
logInfo.Connect ionInfo.ServerN ame = ConnectString.D ataSource
logInfo.Connect ionInfo.Databas eName = ConnectString.I nitialCatalog
tbl.ApplyLogOnI nfo(LogonInfo)
Next

Also can you check if you are using the same version of crystal reporter
assembly, i.e. if the CrystalDecision s.CrystalReport s.Engine.dll is for
net framework 1.1 and CrystalDecision s.Shared.dll is for .net frameword
1.0 which may cause the problem.

Here is the setting on my machine, you may check them in the object browser by pressing Ctrl+Alt+J
Assembly CrystalDecision s.Shared
C:\Program Files\Common Files\Crystal
Decisions\1.1\M anaged\CrystalD ecisions.Shared .dll
Assembly CrystalDecision s.CrystalReport s.Engine
C:\Program Files\Common Files\Crystal
Decisions\1.1\M anaged\CrystalD ecisions.Crysta lReports.Engine .dll

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.