CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    greece
    Posts
    5

    Question Crystal Reports - DSN

    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
    Last edited by etatis; June 3rd, 2003 at 07:34 AM.
    klain main froilain...

  2. #2
    Join Date
    Jun 2003
    Location
    greece
    Posts
    5
    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
    klain main froilain...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured