Weird Mysql data type selection

[mmurdock]

Why is it that the report writer says that "student_list" is a byte array? I'm using mysql .net connector 5.2.5 and stimulsoft 2009.1.33.8. What is weird is if I change it to string the report writer seems to ignore it.

Thanks,

Mat

SELECT distinct
concat(concat_ws(', ', sis_student_info.last_name, sis_student_info.first_name),'-',sis_student_enrollment.student_id) as student_list
FROM
sis_student_enrollment
Inner Join sis_student_info ON sis_student_enrollment.student_id = sis_student_info.student_id
Inner Join sis_course_semester ON sis_student_enrollment.semester_id = sis_course_semester.semester_id
Inner Join sis_course_school_year ON sis_course_semester.school_year_id = sis_course_school_year.school_year_id
WHERE
sis_student_enrollment.withdrawn = 'N'
{student_filter_list}

[Edward]

Hi Mat,

Could you please send us more detail about your task?

Thank you.