locked
need fast help RRS feed

  • Question

  • User-1680333004 posted

    hi all i have a crystal report wirh wo datasource  (oracle and sql2005)

    how i can pass login info to these datasource using        asp.net code (vb.net)

    at the same time

    i can only pass for one datasource what about the second one

    Private Sub configureCRYSTALREPORT1()
            Dim myConnectionInfo As New ConnectionInfo()
    
            myConnectionInfo.ServerName = "Sname"
            myConnectionInfo.DatabaseName = "MyDB"
            myConnectionInfo.UserID = "user"
            myConnectionInfo.Password = "PW"
            setDBLOGONforREPORT(myConnectionInfo)
        End Sub
    
        Private Sub setDBLOGONforREPORT(ByVal myconnectioninfo As ConnectionInfo)
            Dim mytableloginfos As New TableLogOnInfos()
            mytableloginfos = reportviewer1.LogOnInfo
            For Each myTableLogOnInfo As TableLogOnInfo In mytableloginfos
                myTableLogOnInfo.ConnectionInfo = myconnectioninfo
            Next
            mytableloginfos.MergeByConnection(mytableloginfos)
    
        End Sub
    
    
    in the page_load i call
    configureCRYSTALREPORT1()
    Monday, February 27, 2012 4:19 AM

All replies

  • User-1680333004 posted

    any idea guys

    Monday, February 27, 2012 9:07 AM
  • User-1680333004 posted

    Cry

    Tuesday, February 28, 2012 5:33 AM
  • User-37275327 posted

    check this one

    http://www.tek-tips.com/faqs.cfm?fid=4870

    Wednesday, February 29, 2012 2:08 AM