Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    How can I run old Report Generator reports from a client machine with ION Enterprise 6 /StruxureWare Power Monitoring 7/ Power Monitoring Expert 7.2/8 ?

    Issue
    ION Enterprise 6.0 replaced the old Excel-based Report Generator with Web Reporter. However, some users may have created custom Report Generator reports that they still want to be able to run in an ION Enterprise 6.0 environment.

    NOTE: In the case that one wants to report on an ION database from another older ION server (such as a version 5.6 system, for example), there is an article which gives the process for setting up the access to such a database in the article FA214041 "Generating Report from an Archive database that is from another Server"

    Product Line
    ION Enterprise 6.0.x
    StruxureWare Power Monitoring 7.0.x
    Power Monitoring Expert 7.2.x
    Power Monitoring Expert 8.0

    Environment
    Report Generator
    RepGen

    Cause
    Changes made for ION Enterprise 6.0 make running Report Generator reports from ION Enterprise client machines less accessible. Among the changes made:

    1. It is not obvious during the installation process that RepGen is even installed on a client, since at install time, the options available on a client install include Vista, Designer, Management Console and Web Reporter.
    2. The Archive DTS package no longer creates a DSN on the Primary machine for RepGen to use. In addition, the .reg file called ION_DsnKeys.reg is no longer created. This means that DSNs for archived databases need to be set up manually (the User Guide is incorrect)


    Resolution
    To answer cause 1, the required RepGen files are installed on all client and secondary machines.

    What follows is the procedure for creating a DSN manually:

    NOTE: If you are using a 64-bit operating system, run the 32-bit ODBC Administrator tool (%windir%\SysWOW64\odbcad32.exe) in command prompt.
    • 1. Start Control Panel -> Administrative Tools -> ODBC Data Source Administrator, choose the System DSN tab, and click Add:


      2. Choose the SQL Server driver and click Finish:

      3. Type in a Data Source Name. Its best to use a name that clearly identifies the database that you are wanting to connect to. Be sure to append it with so RepGen will see it. Note that Data Source names are limited to 32 characters. Select the SQL Server instance that your database is attached to, then click Next:
     
    • 4. Choose SQL Server authentication, and type in Report for the login ID and reporter! For the password, then click next.
      Note: The password for the report user has changed between versions of the software
      PME 7.2, password is rep0rter!


      5. Check the Change the default database to: checkbox, and select your archived database from the dropdown list, then click Next:


      6. Accept the defaults in the next screen and click Finish. Use the Test Data Source button to be sure that you configured the DSN correctly, then click OK, and then OK again to close the ODBC Data Source Administrator.
    NOTE1: In ION Enterprise 6.0, the legacy Reporter interface is linked to the Web Reporter option during the Client installed. If this is not selected then Reporter will not be installed. You can still install this interface, however, via the following procedure:

    - Insert the ION Enterprise 6.0 DVD
    - Go to add/remove programs -> ION Enterprise -> Change
    - Run the modify task and enable the Web Reporter option. This will install Reporter on the client.

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance