Results 1 to 5 of 5

Thread: Help me pls ! error in VB.Net connection false to Crystal Report XI

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2008
    Posts
    4

    Red face Help me pls ! error in VB.Net connection false to Crystal Report XI

    Hi,
    I will do project VB.Net 2003 ,I have error runtime but i don't know it's mean.
    I wan't query sql show in CrystalReportViewer . But is error
    Somebody please help with the code or a way of fixing this problem.

    Code

    Dim report As New Report1
    Dim SqlString As String = "SELECT * FROM TBL_FJT_TEST WHERE ID_LOT_NO ='" & dmRow_Id & "'"
    CrystalReportViewer1.ReportSource = report

    Dim dt As New DataTable
    Dim da As New SqlDataAdapter(SqlString, conn)
    da.Fill(dt)

    report.Database.Tables(0).SetDataSource(dt)
    CrystalReportViewer1.ReportSource = rpt1
    Attached Images Attached Images  

  2. #2

    Thread Starter
    New Member
    Join Date
    Feb 2008
    Posts
    4

    Re: Help me pls ! error in VB.Net connection false to Crystal Report XI

    I have done various kinds already but I can not .

    How to do ?

    Code Use dataset

    Dim myDa As New SqlDataAdapter( _
    "SELECT * FROM TBL_FJT_TEST WHERE ID_LOT_NO ='" & dmRow_Id & "'", _
    northwindConnection)
    Dim ds As DataSet
    myDa.Fill(ds, "TBL_FJT_TEST")
    rpt1.Load(Application.StartupPath & "/Report1.rpt")
    rpt1.SetDataSource(ds)
    CrystalReportViewer1.ReportSource = rpt1

  3. #3
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Help me pls ! error in VB.Net connection false to Crystal Report XI

    Welcome se_juneke
    Is the DB available at the location supplied to the CR

  4. #4

    Thread Starter
    New Member
    Join Date
    Feb 2008
    Posts
    4

    Re: Help me pls ! error in VB.Net connection false to Crystal Report XI

    Quote Originally Posted by VBFnewcomer
    Welcome se_juneke
    Is the DB available at the location supplied to the CR
    Thanks you.

    I don't know location paste where DB of CR
    do you have Example for me..
    please.....

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Help me pls ! error in VB.Net connection false to Crystal Report XI

    He means is the database located where Crystal Reports is being told it is located.

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