Results 1 to 4 of 4

Thread: [2005] Generate Report between two dates

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2008
    Posts
    104

    Question [2005] Generate Report between two dates

    Hi i have some problem in genrating report between two dates

    I have designed the crystal reports for that and it is multiple tables

    Now i want to find the records between two dates which are passed by user

    And then i want to generate the report between that dates

    Can anyone help me ? please

    Thank you in advance

    Need help badly

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: [2005] Generate Report between two dates

    Could be
    1.- Ask for the dates range inside the application, generate the table or recordset or dataset that crystal reports will read
    or
    2.- In Crystal Reports, insert a parameter field that ask the user for a range of dates and use that Parameter field in the Record Selection formula
    Last edited by jggtz; Jan 3rd, 2009 at 08:48 PM.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jun 2008
    Posts
    104

    Re: [2005] Generate Report between two dates

    Quote Originally Posted by jggtz
    Could be
    1.- Ask for the dates range inside the application, generate the table or recordset or dataset that crystal reports will read
    or
    2.- In Crystal Reports, insert a parameter field that ask the user for a range of dates and use that Parameter field in the Record Selection formula
    Thank you for your reply.
    First thing i can pass two dates in the parameeter value but in function i cannot find the Between And Operator for the forumla

  4. #4
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: [2005] Generate Report between two dates

    Considering that the Range of Dates Parameter Field is an array, then your RecordSelectionFormula should be as :
    Code:
    {Table.DateField} IN {?DateRangeParameter}
    Last edited by jggtz; Jan 5th, 2009 at 10:57 AM.

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