Showing results 1 to 5 of 5

Thread: SQL Database and Zenon Editor

  1. #1
    bmcbrita Gast

    Default SQL Database and Zenon Editor

    I m trying to create a report which will give me efficiency of the machines. For this reason I have created a new picture but I am confused on how to extract the information of (Alarm Duration, running time of the machine) from the Database.
    I was thinking if I could create new variables and use MATH formulas to calculate the figures that will work but cannot find a way out to extract the values from the database to carry on.
    Your help will be highly appreciated

  2. #2

    Default Re: SQL Database and Zenon Editor


    I assume all the data is available in a database, just to use them within the zenon report!?

    Are we talking about the database filled by the IPA module from zenon?

    The zenon report offers a function which collects data directly from a database in order to be shown in the report. Calculations can be done in the report directly as well.

    Please check out the zenon Online Help for the Report Generator and look for the function sqldao() , which gives you the desribed possibility.

  3. #3
    bmcbrita Gast

    Default Re: SQL Database and Zenon Editor


    Yes I want to extract the values of few fields from the IPA table.

    I would like to see figures automatically calculated in Zenon Runtime. I have already created a picture type report and set a function of picture switch in the editor but when I save these changes in the runtime and try to run it, I cannot see the report in the Zenon runtime.

    Do i have to do anything else rather than creating a picture switch ???


  4. #4

    Default Re: SQL Database and Zenon Editor


    did you enter the default control elements?

    So if you have open the picture of type "Report", select from the zenon Editor Menu Bar "Control Elements" -> "Default" and all the control elements are placed within the picture!

    After compilation and picture switch to this picture in the runtime you should see what you expect.


  5. #5

    Default Re: SQL Database and Zenon Editor

    Maybe you would also want to take a look at the function "create IPA document" which could e.g. be triggered through time control on a regular basis.

Similar Threads

  1. Replies: 5
    Last Post: 30th July 2018, 10:45
  2. How to draw mimics in zenon Editor
    By nahala in forum zenon Supervisor
    Replies: 4
    Last Post: 27th April 2009, 08:31
  3. can't create new project in zenon editor
    By shahramkh59 in forum zenon Supervisor
    Replies: 3
    Last Post: 15th April 2009, 07:12
  4. Replies: 0
    Last Post: 20th August 2007, 17:04
  5. The zenOn Editor crashes at startup!
    By wolfgangm in forum zenon Supervisor
    Replies: 0
    Last Post: 13th August 2007, 16:16

Posting Rules

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