I have a field (squad) in a report that i want to group on and show a total for each group..the squad value is an integer from 1 to about 100
Now to the mess...i want to group the field on three values or rather three groups of values..
squad = 2
squad = 3
squad = all but 2 and 3
its the last one i cant get to work, im trying out some expressions but no luck, i have added a foot for the group squad and there i added a count(*)
Any idea on the syntax of the expression to get the last one to group correctly?
Now to the mess...i want to group the field on three values or rather three groups of values..
squad = 2
squad = 3
squad = all but 2 and 3
its the last one i cant get to work, im trying out some expressions but no luck, i have added a foot for the group squad and there i added a count(*)
Any idea on the syntax of the expression to get the last one to group correctly?