Change Database at Run Time of Sub-Report?

[nomi2000]

Dear fellow Programmer
i have done to change the DB of Main Report by
'Database Setting For Main Report
For intTables = 1 To ReportObject.Database.Tables.Count
ReportObject.Database.Tables(intTables).Location = ReportDatabaseName & ".dbo.Proc(stp_ORD_GetOrderItemsByOrderID;1)"
ReportObject.Database.Tables(intTables).SetLogOnInfo ReportServerName, ReportDatabaseName, UserName, Password
Next intTables

But not being able to change the DB of sub-reports how it will be done please help
Regards
Nouman

 

[latwv]

Do it the same way you did with the main report except put .OpenSubreport("SubRptName&quot between the ReportObject.Database

For example

ReportObject.OpenSubreport ("SubRptName&quot.Database


Hope this helps
Lori