I have a formula in the detail section of CR9:
if {SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE}="VENDONSITE"
then {SERVICE_CALL_EVENT.ACTION_DT}
I cannot place this in my group footer section. However, for reasons I don't want to get into now, I need to have this in group footer. The only way I can get this to appear is by summarizing it in a formula:
maximum ({@vendoronsite})
When I run my report and there are multiple hits (group = service_call_id), the maximum formula does not reset.
How do I get this to reset? I vaguely remmeber doing a 'reset' at the report header (??) a long time ago, but can't pinpoint the report on my system to see how I did it.
Any suggestions?
if {SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE}="VENDONSITE"
then {SERVICE_CALL_EVENT.ACTION_DT}
I cannot place this in my group footer section. However, for reasons I don't want to get into now, I need to have this in group footer. The only way I can get this to appear is by summarizing it in a formula:
maximum ({@vendoronsite})
When I run my report and there are multiple hits (group = service_call_id), the maximum formula does not reset.
How do I get this to reset? I vaguely remmeber doing a 'reset' at the report header (??) a long time ago, but can't pinpoint the report on my system to see how I did it.
Any suggestions?