CHANGE CR9 SUBREPORT DB AT RUNTIME

[kissarmi]

I am changing the database for my CR9 report at runtime using a Visual Basic application and this code:

For x = 1 To REPORTNAME.Database.Tables.Count
With REPORTNAME.Database.Tables(x).ConnectionProperties

.Item("Database&quot = "DATABASENAME"
.Item("Server&quot = "SERVERNAME"
.Item("User ID&quot = "USERID"
.Item("Password&quot = "PASSWORD"

End With

REPORTNAME.Database.Tables.Item(x).Location = REPORTNAME.Database.Tables.Item(x).Location

The database change is working for the main report, but I need some help in changing the database for the subreports. How do I loop thru the subreports in order to change their database?

Thanks.

 

[vidru]

Um, first off, have you tried or responded to any of these suggestions: thread149-661720, thread149-662280, or

http://support.crystaldecisions.com/forums/message.asp?fid=76&sk=5&ps=25&pn=1&mid=105384

?

-dave