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 ...
    • 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 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 ...
    • 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 ...
    • Unable to access network drive

      Symptom When attempting to access the network drive you are presented with the error: "Network resource is not accessible. You might not have permission to use this network resource. Contact the administrator of this server to find out if you have ...