James,

Set up a report variable nMales to SUM with the expression IIF(Gender = "M", 1, 0) and another report variable nFemales to SUM with expression IIF(IIF(Gender = "M", 0, 1). Set these to group as needed. You may need two sets of variables, one for the class grouping and one for the section grouping.


>Hi Group
>
>I have a report from a remote view and all of the fields are grouped.
>
>How do I report the number of females and the number of males takeing class.
>Genderc has values of F and M.
>
>The report breaks down the student body by class and section number.
>
>The number in a section and total number taking class is reproted in the section and class group footers.
>
>Thanks
>Jim