Jack Schit
Member
Hi All,
I am very new to SQL database logging and I'm looking for a bit of advice!
At the end of each hour I log number of cases produced, target cases (100% eff) and current product format to a SQL database using WinCC V7.0.
I want to be able to create a report in WinCC that can select a time period & product format. The report should then produce efficiency and total cases for that time period & format.
I realise this will probably require some form of scripting but I have very little experience in this area.
I was hoping someone could give me some advice of how to approach this.
Thanks
Jack
I am very new to SQL database logging and I'm looking for a bit of advice!
At the end of each hour I log number of cases produced, target cases (100% eff) and current product format to a SQL database using WinCC V7.0.
I want to be able to create a report in WinCC that can select a time period & product format. The report should then produce efficiency and total cases for that time period & format.
I realise this will probably require some form of scripting but I have very little experience in this area.
I was hoping someone could give me some advice of how to approach this.
Thanks
Jack
