Reports filtered by dynamic queries hang after updating SQL Instance to Microsoft SQL Server 2008 R2

The Raiser's Edge hangs when running certain reports that are filtered using a dynamic query after updating to a Microsoft SQL Server 2008 R2 instance.
Download and install the latest version and patch, if applicable. 


If you are filtering Total Summary Amounts for Gifts using a dynamic query:
  1. Convert the dynamic query to a static query
  2. Set the static query to be refreshed on a nightly basis through the Queue Module,



Was this article helpful?