Skip to Content
0

Crystal Report - Date Parameter Null value

Jun 01, 2017 at 01:57 PM

31

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Don Williams
Mar 01 at 03:14 PM
0

Moved to CR Designer tag

Share
10 |10000 characters needed characters left characters exceeded
Danilo Kasparian Mar 01 at 03:22 PM
0

Try to use HasValue instead of isnull

if(HasValue({?fromdate}) then

{orderdates.releasedate} = {?fromdate}

else

true

Share
10 |10000 characters needed characters left characters exceeded