[Crystal Reports v8.5]
Greetings,
Is it possible to simplify the following formula:
-----------------------------------------------------------
Whileprintingrecords;
Global numbervar Mth1_CallRcvdCt:= If Month({@Date Mth1 Start})=Month({ACD_STATS.Date}) then {ACD_STATS.Call_Rcvd} else Mth1_CallRcvdCt;
Global numbervar Mth2_CallRcvdCt:= If Month({@Date Mth2 Start})=Month({ACD_STATS.Date}) then {ACD_STATS.Call_Rcvd} else Mth2_CallRcvdCt;
Global numbervar Mth3_CallRcvdCt:= If Month({@Date Mth3 Start})=Month({ACD_STATS.Date}) then {ACD_STATS.Call_Rcvd} else Mth3_CallRcvdCt;
------------------------------------------------------------
The formula is used to retrieve values for a manual cross-tab. An automated cross-tab would produce the relevant figures but for various reasons this is not the method i seek. Is it possible to declare a variable using a formula as this may help?!?
Thanks
Greetings,
Is it possible to simplify the following formula:
-----------------------------------------------------------
Whileprintingrecords;
Global numbervar Mth1_CallRcvdCt:= If Month({@Date Mth1 Start})=Month({ACD_STATS.Date}) then {ACD_STATS.Call_Rcvd} else Mth1_CallRcvdCt;
Global numbervar Mth2_CallRcvdCt:= If Month({@Date Mth2 Start})=Month({ACD_STATS.Date}) then {ACD_STATS.Call_Rcvd} else Mth2_CallRcvdCt;
Global numbervar Mth3_CallRcvdCt:= If Month({@Date Mth3 Start})=Month({ACD_STATS.Date}) then {ACD_STATS.Call_Rcvd} else Mth3_CallRcvdCt;
------------------------------------------------------------
The formula is used to retrieve values for a manual cross-tab. An automated cross-tab would produce the relevant figures but for various reasons this is not the method i seek. Is it possible to declare a variable using a formula as this may help?!?
Thanks