If you want to print this summary at the end of the report, this will not work, but if you want the summary for each employee in the group footer for each employee:
1. Create a variable in the report, one for each type of leave that is possible
2. Group report by Empno and reset the variables on this group
3. For each variable, set initial value to 0, and the value to store for each variable should be iif(leave = < leavetype >,1,0) and calculate sum.
4. Put a field in the group footer for each of the summary variables
HTH
>i have this report,
>
>
>
>
> April 2002
>Empno: 00001
>Day Leave
>1 V
>2
>3 S
>4 S
>5 T
>.
>.
>.
>.
>.
>.
>30
>
>
>
>i want to print a summary of all leave type of each employee. like V = 1, S = 2, T = 1
>
>leaves per employee are not the same.
>
>any idea on how i can do this?