XL Reporter, Team Explorer, Historian Excel Add-In

XL Reporter, Team Explorer, Historian Excel Add-In


Symptom

XLReporter`s Team Explorer extension not functioning properly with reports using Historian Excel Add-In

 

Environment

Primary Product Module : Team Explorer
Primary Product Version : 12.5
Primary Product OS : Windows Server 2012 R2 x64

Cause

each "Connection" must be set to the proper Category and Type, Load User Profile is set to True

Resolution

In order for the Reports which use the Historian Excel Add-In within the Team Explorer extension of XL-Reporter to function properly the correct settings must be configured.
      First of all each "Connection" must be set to the proper Category and Type. The Category should be Data Import, and the Type should be From Add-in Formulas. See the attached image titled Connections_Manage_Settings for a visual image of correct settings.
      If your Report is still not functioning properly within Team Explorer you will need to configure the IIS Manager settings on the machine hosting XL-Reporter to function properly.
Open your Server Manager > IIS Manager > Extend server name in Connections pane on left hand side and choose
Application Pools > Navigate too XLRwebpool right click and open Advanced Settings > Process Model ensure Load User Profile is set to True. Also under Process Model you may need to set a custom account.

    • Related Articles

    • XLReporter Team Client Installation

      Overview This is a step-by-step walkthrough for installing XLReporter`s Team Client application onto a machine located on the XL Report Server network. Pre-Requisites XLReporter v 9.0 or newer must be installed on a Server located on the same network ...

    • How To Add local Terminal Server User

      Below are the steps required to create a new user account within Windows Server 2016 and Make sure that the user is a member of the Remote Desktop Users Windows group. While Windows Server 2016 offers some new interface options and menus that can be ...

    • How To - Test iFIX & Historian Redundancy / Make edits to redundant iFIX SCADA Servers

      Overview This is a guide on how to test a redundant iFIX and Historian iFIX collector environment. As well as preforming development updates to a redundant iFIX server pair. Pre-Requisites iFIX 5.X redundant SCADA servers configured. Historian ...

    • iFix Terminal Server Add User with auto login

      Requirement We need to add a new RDP user to iFix for remote connection. This use needs a node name and the auto-login should log them into guest as a best practice. Environment Primary Product Module : GE iFix Primary Product Version : 5.8/5.9 ...

    • How to add a file to the startup folder in Windows 10

      Open file explorer Go to the C:\ folder as shown below In the drop down, type C:\PROGRAMDATA and hit enter. You are now in the ProgramData folder as shown below. Double click on Microsoft folder and you will be in the Microsoft folder as shown below. ...