Customised Report in Citect SCADA

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
  • I agree, don't use citect reporting for this, as it's super basic and doesn't offer any functionality. I would be embedding a webpage into your citect page and display an ssrs for your report.

    Edit: this assumes you're using MS SQL server as your database, but most other databases will have their own reporting services as well

Reply
  • I agree, don't use citect reporting for this, as it's super basic and doesn't offer any functionality. I would be embedding a webpage into your citect page and display an ssrs for your report.

    Edit: this assumes you're using MS SQL server as your database, but most other databases will have their own reporting services as well

Children
No Data