include errors in report generating page
add where clause for diagnosis to the report generating module