Results 1 to 5 of 5

Thread: generate Reports for the particular range of dates

  1. Jan 5th, 2006, 01:29 AM #1
    eeeravi
    eeeravi is offline

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    12

    generate Reports for the particular range of dates

    hi,
    i am developing a vb application. in that i want to generate Crystal reports for a particular range of dates.

    Eg:

    Starting date month and year in one combo box
    Ending date ,month and year in another combo box..


    which query i've to use to solve this problem... i'll be happy if you give me any solution..

    thanx,
    Ravi.
    Reply With Quote Reply With Quote
  2. Jan 5th, 2006, 05:31 AM #2
    mvirendra
    mvirendra is offline
    Junior Member
    Join Date
    Dec 2005
    Location
    Surat,India
    Posts
    29

    Re: generate Reports for the particular range of dates

    Hi

    Just Build your query as per your requirement and then set it to report's
    sqlQueryString.
    Virendrasinh Narendrasinh Mahida
    ----------------------------------
    There is Never a WRONG time to do the RIGHT Thing
    Reply With Quote Reply With Quote
  3. Jan 5th, 2006, 07:01 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: generate Reports for the particular range of dates

    Moved to reporting section
    Reply With Quote Reply With Quote
  4. Jan 6th, 2006, 02:30 AM #4
    KGComputers
    KGComputers is offline
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,024

    Re: generate Reports for the particular range of dates

    Hi.....

    Try Using DTPicker Control....It's in the Microsoft Common Controls-2 6.0
    It will return values for specific dates...
    Reply With Quote Reply With Quote
  6. Jan 6th, 2006, 03:55 AM #5
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: generate Reports for the particular range of dates

    The sql for such is usually like the ff...

    VB Code:
    1. "SELECT * FROM Table WHERE fldDate BETWEEN #" & cboDate1 & "# AND #" & cboDate2 & "#"
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    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