(Select {?p_Period} [5 to 6]
case "12" :
ToText((ToNumber(Left({?p_Period},4))),0,"","")
default :
ToText((ToNumber(Left({?p_Period},4))-1),0,"",""))
&
(select {?p_Period} [5 to 6]
case "12" :
"01"
case "10", "11" :
ToText((ToNumber(Right({?p_Period},2))+1),0)
default:
"0"&ToText((ToNumber(Right({?p_Period},2))+1),0))
I am fixing reports that have been developed and I am not sure on this logic. I am trying to export my data out to excel and two records format way over to the right when they should be to the left with the other records ( They are in a group header)
IP Logged
