How to change the database of the subreport

[Ray]

Dear all,
By using the following code, I can change the database name of the
crystal report

....
Dim ReportTemp As New ReportDocument
ReportTemp.Load(_report)

For Each table In ReportTemp.Database.Tables
pPrintSetting.OriDataBase = table.Location
pPrintSetting.GetInfo()
logoninfo = table.LogOnInfo
With logoninfo.ConnectionInfo
.ServerName = pPrintSetting.ServerName
.DatabaseName = pPrintSetting.DatabaseName
.UserID = pPrintSetting.UserID
.Password = pPrintSetting.Password
End With
table.ApplyLogOnInfo(logoninfo)
table.Location = String.Concat(pPrintSetting.DatabaseName,
".dbo.", table.Location.Substring(table.Location.LastIndexOf(".") + 1))
Next table
ReportTemp.RecordSelectionFormula = _select
....

However, if there is a subreport in the report, the subreport's database
name cannot be changed, is it possible to change the database name of the
subreport?

Thanks a lot,
Ray

 

[Peter Proost]

Hi, try this link

http://makeashorterlink.com/?P644220FA

hth Peter

 

[Cor Ligthert]

Peter,

When you use this one then there is build in something to make shorter
links.
http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb

Cor

 

[Peter Proost]

Hi Cor,

I must be blind or something because I already use the beta but I don't see
the thingy for makeing shorter links

Greetz Peter

 

[Cor Ligthert]

Peter

When you are one a message.

"Show options" and than "individual message"

Than you have a (relative) short link in my opinon good for a message

http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb/msg/080f92f0cdca832f?hl=en


Cor

 

[Peter Proost]

Cor,

thanks for the tip. I was looking for something called get a shorter link,
or make a short link that's why I didn't find it

Greetz Peter