When we encountered excessive blocking issues with reports, one tempting solution was to use the WITH NOLOCK table hint to get the report running smoothly and avoid blocking behavior completely.