CodeGuru Forums -
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic Newsletters VB Forums Developer.com


Newest CodeGuru.com Articles:

  • Installing SQL Server 2008
  • Writing UDFs for Firebird Embedded SQL Server
  • [Updated] Shutdown Manager
  • Building Windows Azure Cloud Service Applications with Azure Storage and the Azure SDK

  • Search CodeGuru:
     



    Go Back   CodeGuru Forums > Visual Basic Programming > Crystal Reports
    FAQ Members List Calendar Search Today's Posts Mark Forums Read

    Reply
     
    Thread Tools Search this Thread Rate Thread Display Modes
      #1    
    Old March 15th, 2004, 02:05 PM
    BinaryAnge's Avatar
    BinaryAnge BinaryAnge is offline
    Member
     
    Join Date: Nov 2002
    Location: Columbus, Ohio
    Posts: 117
    BinaryAnge is an unknown quantity at this point (<10)
    Need to select between 2 dates

    I need to create a report for a time period. The dates of the transactions are in the db. How do i tell crystal reports to select the records between 2 dates. I created 2 parameter fields "from" and "to"; how do i add them to the select statement that the viewer uses?
    __________________
    Its better to have people think you're a fool than to open your mouth and remove all doubt.
    Reply With Quote
      #2    
    Old March 16th, 2004, 03:27 PM
    James Longstreet James Longstreet is offline
    Member
     
    Join Date: Apr 1999
    Location: VA BEACH
    Posts: 467
    James Longstreet is an unknown quantity at this point (<10)
    you can add it to your record selection critera in the report;

    IF DateField > ?ParamName and DateField <= ?ParamName, or some hybrid of that.
    Reply With Quote
      #3    
    Old March 16th, 2004, 04:19 PM
    harmonycitra harmonycitra is offline
    Member
     
    Join Date: May 2003
    Posts: 163
    harmonycitra is on a distinguished road (20+)
    One more way

    U can also use the folg. code in your record selection formula

    {Datafld} in {?from} to {!to}
    Reply With Quote
    Reply

    Bookmarks
    Go Back   CodeGuru Forums > Visual Basic Programming > Crystal Reports


    Thread Tools Search this Thread
    Search this Thread:

    Advanced Search
    Display Modes Rate This Thread
    Rate This Thread:

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off
    Forum Jump


    All times are GMT -5. The time now is 05:11 PM.



    Acceptable Use Policy

    internet.comMediabistrojusttechjobs.comGraphics.com

    WebMediaBrands Corporate Info


    Advertise | Newsletters | Feedback | Submit News

    Legal Notices | Licensing | Permissions | Privacy Policy


    Powered by vBulletin® Version 3.7.3
    Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
    Copyright WebMediaBrands Inc. 2002-2009