Crystal Report Change Table.Location Prob.

[aboobackerpm]

Hai friends
I am using VB.net 2005 crystal report,SqlServer 2005. my report with stored procedure. foll. code is to change the database of reports ...

For Each crTable As Table In crdoc.Database.Tables

            crTableLogonInfo = crTable.LogOnInfo
            crTableLogonInfo.ConnectionInfo = ObjGlobal.ConInfo
            crTable.ApplyLogOnInfo(crTableLogonInfo)
            crTable.Location = ObjGlobal.ConInfo.DatabaseName & ".dbo." &  crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)


        Next

my problem is when i change the location of table report is not showing result

any one can help me pls..........