PROBLEM

Reports are stuck in a Pending status on the server.

SYMPTOMS

Reports are stuck in pending status.  If multiple reports are run, you will see the excel process numerous times in Task Manager unless auditing is enabled.  If auditing is enabled, it will eventually cause the report to display 'Failed'.

The Reporting.txt log shows absolutely nothing about the report being run, and the reporting service is started and funcitonal.

Attempting to export an Inspector report to excel also exhibits the same issue, where it will never complete the export.

Customer is using Excel 2007 

CAUSE

VBA is disabled in Microsoft Office, which in turn limits excel functionality, including report generation.

For more information please reference the following:  http://support.microsoft.com/kb/282847

RESOLUTION

You can open Excel and try the following:

1. Click the Office Button (top-left most button in the window)
2. Click the Excel Options button.
3. Click Trust Center in the menu on the left.
4. Click Trust Center Settings in the window on the right.
5. In the new window that opens click Macros in the menu on the left.
6. Check the box next to Trust Access to the VBA project object model.
7. Click OK.
8. Click OK.
9. Close all Office applications and try your project again.


If this does not work, you will need to add the VBA feature to Excel.

1. Go to the Control Panel.
2. Right-click Microsoft Office 2007 and select Change. 
3. When the Office screen comes up select Add-Remove Features.
4. Expand the Office Shared Features section and select Visual Basic for Applications.
5. Choose Run from My Computer.
6. Click Continue and follow the on-screen prompts to finish the feature change.
7. Go to Start => Run and type services.msc .
8. Restart the prairieFyre Reporting Service.

APPLIES TO

CCM all versions, Excel 2007