Management Reporter 2012 - How to Delete Report Queue Manually?

All the Report Process are stored in the Management Report Database under the table "Repository".
To manually remove reports that are stuck in Queue status, use the below SQL scripts.

1. Log in to SQL Management Studio with admin privilege.
   
   
2. Run the below script against Management Reporter Database
   
   USE ManagementReporter
   -- View the Records
   Select * from repository where StatusType = 30
   or
   Select * from repository where StatusType = 30 and Name '<Report Name>'
   
   -- Delete the Records
   Delete Repository where StatusType = 30 and Name '<Report Name>'
   
   
3. Open Management Reporter and Check if this has cleared all the Report Queue.
   Tools >> Report Queue Status.