• Replies 7 replies
  • Subscribers 584 subscribers
  • Views 465 views
  • Users 0 members are here
Options
Related

Customised Report in Citect SCADA

Purusothaman

Hello Team,

I have a project where i am working for generating customised report in Citect SCADA. I have partially done something to achieve, however need your support to complete it. 

I have logged all the real time data into SQL database using ODBE configuration. I am able to see the datas with timestamp in database.

Now when i click report, one popup has to come-up and should have a options to select starting date, starting time, ending date and ending time. when i click report button on the same screen, datas has to be fetched from database and stored in the excel sheet by using writing cicode  / Citect VBA .

Thanks and Regards,

Purusoth

Parents
  • Hi All,
    I think Anton said is correct you can use activeX for embedding the webpage in your SCADA and by MS SSRS you can publish your report over web page.
    Since you're able to log the data into SQL database your next step is just to fetch the data in your desired format.
    That you can do by using SQL server Data tools(Microsoft Visual Studio).
    If you're using freeware of MS SSRS then you've limitation of manipulation of Data upto 4GB max.

    Another way to achieve your desired output is by using following Cicode function
    1) FileCopy (this function will create new excel file in your predefined format).
    2)Exec (this will open your newly created file).
    3)DDEWrite functions (It will copy the Points value to Excel file and close the file).
    run this Cicode as an Event in your system.
    If you're having small number of points(Tags) to log then this one is the better way
Reply
  • Hi All,
    I think Anton said is correct you can use activeX for embedding the webpage in your SCADA and by MS SSRS you can publish your report over web page.
    Since you're able to log the data into SQL database your next step is just to fetch the data in your desired format.
    That you can do by using SQL server Data tools(Microsoft Visual Studio).
    If you're using freeware of MS SSRS then you've limitation of manipulation of Data upto 4GB max.

    Another way to achieve your desired output is by using following Cicode function
    1) FileCopy (this function will create new excel file in your predefined format).
    2)Exec (this will open your newly created file).
    3)DDEWrite functions (It will copy the Points value to Excel file and close the file).
    run this Cicode as an Event in your system.
    If you're having small number of points(Tags) to log then this one is the better way
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.