Summary:
Pivot reports use the Microsoft Excel PivotTable and PivotChart features to provide easy to use customization options and the ability to generate graphical representations of report data. Unlike other reports in Web TimeSheet, Pivot Report can't be run directly. It requires a Microsoft Web Component to be installed prior to running the report and this Web Component works only with Internet Explorer.


Resolution:
1. In Internet Explorer, the following message appears when tried to run the Pivot Report,
The report cannot be displayed because the Microsoft Office XP Web Components are not installed. Click here to download the necessary .EXE file. Then run the .EXE to install the Microsoft Office XP Web Components on your local machine.

Note:
The Click here is a hyperlink which would take you to the following Microsoft Download Center from where you can download the Microsoft Office XP Web Components,

https://www.microsoft.com/en-us/download/default.aspx

Once the installation is complete, you will be able to view Pivot Reports however; if you are unable to generate pivot reports even after installing Office Web Components, then follow the steps given below,

  • Choose 'Internet Options' from the Tools menu.
  • Click on the 'Security' Tab.
  • Click on the 'Trusted Sites' icon.
  • Click on the 'Sites' button.
  • Ensure 'Require server verification (https:) for all sites in this zone' is unchecked.
  • Add the Web TimeSheet URL as a trusted site.
  • Click OK to close this dialogue window.
  • Click the 'Custom Level' button.
  • Scroll down to the 'Miscellaneous' category and ensure that 'Access data sources across domains' is enabled.
  • Again scroll down a little further and you would find an option as 'Websites in less privileged web content zone can navigate into this zone', under the same 'Miscellaneous' category, ensure this option is also enabled.
  • Continue scrolling down to the 'User Authentication' category and ensure that 'Automatic logon with current username and password' is enabled.
  • Click OK to complete the setting adjustment, and OK again to close the Internet Options window.
  • Refresh the Web TimeSheet pivot report page in your browser.
  • Run the Pivot report.
Note:
If it still doesn't work, go to Internet options, click on Security tab and reset the security level zone to low. It should generate the Pivot reports.