changed collation to utf8_unicode_ci
fleshed out report update functionality.