I know this has been discussed somewhere before but I cant seem to find the post again.
What i need to do is alternate the background colour of the group footer in my report. i.e. if there are 10 items in the group then the background colour of the 1st, 3rd, 5th, 7th and 9th item would be grey.
I remember that you have to take a mod of the row number but I cant remember the syntax.
Can anyone help me out?
What i need to do is alternate the background colour of the group footer in my report. i.e. if there are 10 items in the group then the background colour of the 1st, 3rd, 5th, 7th and 9th item would be grey.
I remember that you have to take a mod of the row number but I cant remember the syntax.
Can anyone help me out?