You should not be writing reports against the base tables - use the Filtered
views instead. They are easier to use and will respect the CRM security
of the user running the report. Also they do many of the tedious things
for you like converting date/times to that of the local user, and supplying
you with the text values for all lookups and picklists.
I suggest you have a look at the FilteredIncidentResolution view - it likely
has all the information you need.