dciadmin
IS-IT--Management
- May 10, 2002
- 34
Hi,
Using Crystal Reports 9, I have two parameters setup ... one is for a string and one is a date. I added these to the Select Expert and if they are both filled out by the user then the report works fine ...
What I need to do is have the option to leave the date blank and have the report pull all the dates instead of just one specific one. I read something about making the date parameter into a string and then converting it afterwards but I really would like the user to be able
to choose a date from a "calendar" versus having to type it in ...
So to recap ... the user fills out his order number in the string field and then either hits ok (leaving the date parameter empty) to get that order number with all dates, or he highlights the date parameter and can drop down the box to choose the date.
Seems straightforward but I am not getting it .... Tried this but it came up empty if the date was ignored ..
{co_ship.co_num} like "*"+{?Order Number} and
if(isnull({?Shipped Date})) then {do_hdr.shipped_date} =
AllDatesToToday else {do_hdr.shipped_date}={?Shipped Date}
any insight is appreciated ...
JL
Using Crystal Reports 9, I have two parameters setup ... one is for a string and one is a date. I added these to the Select Expert and if they are both filled out by the user then the report works fine ...
What I need to do is have the option to leave the date blank and have the report pull all the dates instead of just one specific one. I read something about making the date parameter into a string and then converting it afterwards but I really would like the user to be able
to choose a date from a "calendar" versus having to type it in ...
So to recap ... the user fills out his order number in the string field and then either hits ok (leaving the date parameter empty) to get that order number with all dates, or he highlights the date parameter and can drop down the box to choose the date.
Seems straightforward but I am not getting it .... Tried this but it came up empty if the date was ignored ..
{co_ship.co_num} like "*"+{?Order Number} and
if(isnull({?Shipped Date})) then {do_hdr.shipped_date} =
AllDatesToToday else {do_hdr.shipped_date}={?Shipped Date}
any insight is appreciated ...
JL