Skip to Content
avatar image
Former Member

Date range parameter in Crystal Report

I am trying to use the date range parameter for my report.

1) Create a parameter and named it "DateRange".

2) Select 'Date' in date option.

3) In 'Value Options:' I selected 'Allow range values' to true.

4) In 'report-> select expert -> record clicked on <New> tab and select the filed {test.date}

5) Choose 'is equal to' drop down list and set it to 'is equal to'

6) The drop down list next to step 4,  tried to select {?DateRange} but is missing.

Note: The field {test.date} is in YYYY-MM format like 2104-11.

I would appreciate if you can help me.

-Bill

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 20, 2014 at 06:31 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2014 at 06:32 PM

    Hi Bill,

    Check the datatype of your data parameter here.

    Edit parameter->type 

    .It should be same as your date field datatype

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Bill,


      Can you try other way to create data range parameters like this.

      1.Create a parameter named fromdate and select your datefield.

      2.Ceate 2nd parameter todate and select your datefield.

      3.Goto record selection formula write like this.

      {Date} in {?Fromdate} to {?ToDate}

  • Nov 20, 2014 at 07:02 PM

    Hi,

       Can you post the screen shot of your parameter in edting mode.

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 20, 2014 at 07:15 PM

    Hi,

         See the below screen shot

    In above screen there is option Allow range values it depends on You either you want to give range in one parameter or you are creating the 2nd paramter for ToDate

    also check the below screen how i created this From Parameter

    Regards,

    Manish


    Date Parameter.jpg (94.1 kB)
    Parameter.jpg (23.0 kB)
    Add comment
    10|10000 characters needed characters exceeded