Hi everybody!
i have a problem here...
how can my report "understands" the new DSN i ve given my DB???
what i mean, is that how can i set my report s DSN dynamically???
thanx
Printable View
Hi everybody!
i have a problem here...
how can my report "understands" the new DSN i ve given my DB???
what i mean, is that how can i set my report s DSN dynamically???
thanx
Hi again!
Thanx everybody who read my post, but i found the way to do it....
if this helps anybody........i m gona be :)
Report.DiscardSavedData
For i = 1 To Report.Database.Tables.Count
Report.Database.Tables(i).ConnectionProperties.DeleteAll
Report.Database.Tables(i).ConnectionProperties.Add "DSN", newDSN
Report.Database.Tables(i).ConnectionProperties.Add "User ID", newID
Report.Database.Tables(i).ConnectionProperties.Add "Password", newPWD
Next i