Results 1 to 3 of 3

Thread: crystal report runtime error 20599 Cannot Open SQL Server

Threaded View

  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
« 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