2/19/2019 2:17 PM | |
Joined: 9/19/2009 Last visit: 5/11/2024 Posts: 458 Rating: (83) |
Hi Can you show a sample? Or how many tags are you taking about? I have done reports with VBScript and Excel and works very well. Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
2/19/2019 4:41 PM | |
Joined: 9/19/2009 Last visit: 5/11/2024 Posts: 458 Rating: (83) |
Hi Gonzalo The second reports seens to be the most complex 4000 querys... If you have diferents datetime, this meant that your tags have to be with TagLogging. If you tags are logging in TagLogging you have to use as you said before Information Server - Data Monitor - Connectivity Pack - ODK, because database are compressed and this addons can connect. This is with WinCC Otherwise, you can create a Database and logging your data, then you can use Report Sever from SQL Server and made your reports with querys SQL . By the way, can you send a report, delete private information, I would like to see it or if you want send me a PM Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
2/20/2019 7:38 AM | |
Joined: 1/15/2018 Last visit: 5/17/2024 Posts: 145 Rating: (5) |
Hi *PHS*, Thank you for the information. I cannot send the file for confindencialy reason, but you can see it on this picture attached. With the addon that iFIX install in excel, you can set the value of a cell. You need to reference the tag name, start time, end time, calculation (average, sum...)... As you said, we need to read it from logging. Is there something similar for WinCC? Custumer uses to work with it, so they want something similar, because they can change some variables without programming knownledge. I had a look of data monitor information but i am not sure that you can do the same, because you can not reference the parameters of the query to other cells of the excel and the output is not a result. It takes all the data of the query. Best regards, Gonzalo Attachmentexcel_query.zip (72 Downloads) |
2/20/2019 9:00 AM | |
Joined: 9/19/2009 Last visit: 5/11/2024 Posts: 458 Rating: (83) |
Hi Gonzalo I don´t think you can do exaclty the same, but the most closest thing is DataMonitor with Add-on Excel and Information Server. Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
2/20/2019 2:37 PM | |
Joined: 1/15/2018 Last visit: 5/17/2024 Posts: 145 Rating: (5) |
Thanks! I will let you know if we can do somthing similar. Best regards, Gonzalo |
Follow us on