Assessment / Instance BI Reports

Summary

Issues with Formatting of Instance / Assessment Report Output

Content

There are some reports that I have to run on some of our Instances/Assessments.   When the output is an Excel file for one user there could be multiple lines because the answers on their assessments have returns in them.  This makes sorting and filters on these reports difficult.  If I have the report come out in a CSV the  answers will show on new lines and not be associated with the User..

The other issue is I have HTML code setup for the Questions and this can result the question coming out on the report in multiple lines.