Skip to Content
avatar image
Former Member

Crystal Report - Date Parameter Null value

Hello,

I am new to Crystal Report 2008 Version 12.6.0. I am trying to put record selection for date range from and to dates are blank then report should pull everything. So, far I enter


if(isnull ({?fromdate}) then true

else {orderdates.releasedate} = {?fromdate}

and

if(isnull ({?todate}) then true

else {orderdates.releasedate} = {?todate}

When I put this is the message I am getting. Please look below.

Please advise me what I am doing wrong.

Thanks,

Brijesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 01 at 03:14 PM

    Moved to CR Designer tag

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01 at 03:22 PM

    Try to use HasValue instead of isnull

    if(HasValue({?fromdate}) then

    {orderdates.releasedate} = {?fromdate}

    else

    true

    Add comment
    10|10000 characters needed characters exceeded