I'm creating a manual crosstab where I'm counting the number of applications that each employee received during a specific month.
I want the employees that haven't received any apps to have a value of 0.
Current Results of the crosstab
1/2004
Hunt 1
Kart 3
Smith 5
Desired Results of the crosstab
1/2004
Baker 0
Hunt 1
Kart 3
Smith 5
Zenith 0
First, I grouped the employee names and placed it in the group footer. That worked
Problem:
Second, I created a formula to place in the Suppressed Details Section. The formula is:
IF MONTH({VRPT_TABPRO.DATOUV}) = 1 and year({VRPT_TABPRO.DATOUV}) = 2004 then {VRPT_TABPRO.CODPRO} = 1 else 0
The VRPT_TABPRO.CODPRO field is an alphanumeric field which holds the app number (i.e. IU9000).
I keep getting the error message that a string is required.
Suppress?
I'm supposed to suppress the the drill down capabilities or the blank section capabilities in the detail section because when I suppress the drill down I can't place my formula field in that section.
I want the employees that haven't received any apps to have a value of 0.
Current Results of the crosstab
1/2004
Hunt 1
Kart 3
Smith 5
Desired Results of the crosstab
1/2004
Baker 0
Hunt 1
Kart 3
Smith 5
Zenith 0
First, I grouped the employee names and placed it in the group footer. That worked
Problem:
Second, I created a formula to place in the Suppressed Details Section. The formula is:
IF MONTH({VRPT_TABPRO.DATOUV}) = 1 and year({VRPT_TABPRO.DATOUV}) = 2004 then {VRPT_TABPRO.CODPRO} = 1 else 0
The VRPT_TABPRO.CODPRO field is an alphanumeric field which holds the app number (i.e. IU9000).
I keep getting the error message that a string is required.
Suppress?
I'm supposed to suppress the the drill down capabilities or the blank section capabilities in the detail section because when I suppress the drill down I can't place my formula field in that section.