Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Post Likes

    BMS Reports from FX Server

    A Customer of ours is currently using an older Metasys Front end with Metalink and Excel to generate monthly reports for different areas in the facility. Is anyone aware of a software that will duplicate this type of functionality with the FX Server? I am not sure if Excel can be set up in a similar manner as it is with the Metasys app to pull trend data into reports.

  2. #2
    Join Date
    Dec 2006
    Post Likes
    Use the Report Service.

  3. #3
    Join Date
    Jul 2008
    Post Likes
    the report service has a few good ways of getting data out.
    The axCommunity and VykonPro jars have a few as well. The VykonProReportSource is a good one that will write to a filename of your choice.

    getting data in to excel...

    ...there are a few gotchas such as having to use a Hx profile, and its easier to have the webquery not be challenged by passwords and stuff like that. Theres plenty of literature but its still frustrating and finicky to get going.

    you can auto export histories to mySQL etc and then use normal ODBC to query....probably the best solution but, there is a cost to this.

    ...there are always products such as ProphetSuite too.
    1 + 1 = 3 ( *** for very large values of 1)

    ...everybody wants a box of chocolates and long stemmed rose

    Be brave. You cannot get eaten by an imaginary tiger.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts