Hi Sergey,

I am going to combine my thank you's for the last three answers into one email thank you, thank you, thank you!

Thanks again
Jim


>I find that it's much easier to prepare all required data and let Report Writer just print it.

SELECT DIST district, Student
>  FROM mytable ;
>  INTO CURSOR crsStudents
>
>SELECT district, Count(*) AS StudentCount ;
>  FROM crsStudents ;
>  GROUP BY 1  ;
>  INTO CURSOR crsCount
>
>SELECT mt.district, mt.Student, mt.Course, mt.Code, sc.StudentCount ;
>  FROM mytable mt ;
>    JOIN crsCount sc ON sc.district = mt.district ;
>  ORDER BY 1, 2, 3, 4 ;
>  INTO CURSOR crsResult
>

>
>>Hello Group,
>>
>>I am supposed to total the number of students coming from the home districts to the career center which should not be hard, just make a district group and report variable.
>>
>>The problem is that the student may be taking more than one class and the cursor I am using for the report is distinct by district, student name, ident,course code, and section number and they want a list of the students and the courses they are taking. At the end of each district they want a count of the students from that district.
>>
>>If the student is taking two different courses at the career center then the he will be in the list twice
>>
>>Battle Creek Jones,Ted Auto Shop 2
>>Battle Creek Jones,Ted Welding 3
>>
>>Ted will be counted as two students and not one.
>>
>>Is there a way around this?
>>
>>Thanks
>>Jim