Results 1 to 3 of 3

Thread: crystal report runtime error 20599 Cannot Open SQL Server

  1. Apr 2nd, 2007, 12:55 PM #1
    gsharathkumar
    gsharathkumar is offline

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    1

    Question crystal report runtime error 20599 Cannot Open SQL Server

    I am using VB6.0 and crystal reports 8.5 the code which i have written is as below

    sql = "{FinalWeeklydata.Shipmentdate} IN date(" & DT1.Year & "," & DT1.Month & "," & DT1.Day & ") TO date(" & DT2.Year & "," & DT2.Month & "," & DT2.Day & ") " & sql2
    CrystalReport1.SelectionFormula = sql
    CrystalReport1.ReportFileName = reportfilepath & "\rpt\ShipmentDetails.rpt"
    CrystalReport1.Action = 1

    i am getting an run-time error 20599 Cannot open SQl Server.

    can anyone help me on this. as i am new to crystal reports i am unable to understand why this error is coming.

    Thanks & reagrds,
    Sharath.
    Last edited by gsharathkumar; Apr 2nd, 2007 at 01:00 PM. Reason: for more clearity
    Reply With Quote Reply With Quote
  2. Apr 27th, 2007, 01:47 PM #2
    Pasvorto
    Pasvorto is offline
    PowerPoster Pasvorto's Avatar
    Join Date
    Oct 2002
    Location
    Minnesota, USA
    Posts
    2,951

    Re: crystal report runtime error 20599 Cannot Open SQL Server

    have you connected the report to the database?
    ===================================================
    If your question has been answered, mark the thread as [RESOLVED]
    Reply With Quote Reply With Quote
  3. May 11th, 2007, 12:23 AM #3
    mabbas110
    mabbas110 is offline
    Addicted Member mabbas110's Avatar
    Join Date
    Oct 2005
    Location
    Karachi , Pakistan
    Posts
    172

    Re: crystal report runtime error 20599 Cannot Open SQL Server

    Please give the logon information during calling. Remove this forumla if u think this formula is creating problem and then run it.
    Thanks and Regards,

    Muhammad Abbas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width