CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 10 of 10

Threaded View

  1. #1
    Join Date
    Apr 2006
    Location
    Kolkata, India
    Posts
    278

    Unhappy Crystal Report XI R2 Problem

    Dear Everyone,

    I have designed the Report manually & in a Command button on a form
    I have written
    Code:
    
    
    Code:
    Dim sStartDate As Date
    Dim sEndDate As Date
    Dim sSQL As String
    
    
    sStartDate = Format(DTPicker1.Value, "dd/mm/yyyy")
    sEndDate = Format(DTPicker2.Value, "dd/mm/yyyy")
    
    
    sSQL = "select * from Sales where SellDate BETWEEN " & sStartDate & " and " & sEndDate
    DataEnvironment1.Partsale sStartDate, sEndDate
    frmPSale.Show
    The Report returns all Records Beyond the dates I entered !!!
    I am using CrystalReports XI R2
    Is there anyone who can help me with this?please...
    Pls help

    Rahul
    Last edited by dsrahul; November 11th, 2013 at 05:27 AM. Reason: No helps !!!

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