I need to set a variable in one subreport that will carry over to other subreports. I am finding that if the date field is blank in one subreport, I get garbage. I want to be able to take the Date field from one subreport and place it in a second subreport if the second subreport Date field is blank and visa versa. My current variable formula is as such:
Global datevar DD;
if trim({list_wpbins4_hist._DATE}) <> ""
then
DD:= Date (tonumber("20"+right(maximum({list_wpbins4_hist._DATE}),2)),tonumber(left(maximum({list_wpbins4_hist._DATE}),2)),tonumber(mid(maximum({list_wpbins4_hist._DATE}),4,2)))
else if trim(totext(DD)) = "" then
CurrentDate
else
DD;
Any suggestions would be greatly appreciated!!!
Global datevar DD;
if trim({list_wpbins4_hist._DATE}) <> ""
then
DD:= Date (tonumber("20"+right(maximum({list_wpbins4_hist._DATE}),2)),tonumber(left(maximum({list_wpbins4_hist._DATE}),2)),tonumber(mid(maximum({list_wpbins4_hist._DATE}),4,2)))
else if trim(totext(DD)) = "" then
CurrentDate
else
DD;
Any suggestions would be greatly appreciated!!!