code_junkie

Replace a database connection for report and all subreports

Nov 10th, 2011
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. #'SET REPORT CONNECTION INFO
  2. For i = 0 To rsource.ReportDocument.DataSourceConnections.Count - 1
  3. rsource.ReportDocument.DataSourceConnections(i).SetConnection(crystalServer, crystalDB, crystalUser, crystalPassword)
  4. Next
  5.  
  6. For i = 0 To rsource.ReportDocument.Subreports.Count - 1
  7. For x = 0 To rsource.ReportDocument.Subreports(i).DataSourceConnections.Count - 1
  8. rsource.ReportDocument.OpenSubreport(rsource.ReportDocument.Subreports(i).Name).DataSourceConnections(x).SetConnection(crystalServer, crystalDB, crystalUser, crystalPassword)
  9. Next
  10. Next
Add Comment
Please, Sign In to add comment