hello everyone i need to calculate the sum of  a column shown in a report in the runtime using c-scripting. my report is sorted by date and i need to calculate the sum during all the period shown.

can anyone help me please.

------------------------------------------------------------------------------------------
Split from Sum of tow analog value in VBS or C_Action.

There is very little in the way of scripting possibilities in WinCC Report Designer.  If you are using WinCC Report Designer for your report, you will either need to do one of the following:

• Generate all the data, including the column totals, in WinCC before running the report
• Pull the data from the report from a SQL Server table, and use SQL statements to aggregate the column data
• Generate a CSV file containing the data using a WinCC script, then include the CSV file in the report as a Runtime Document --> CSV Provider table
• use some other reporting mechanism other than Report Designer to generate the report.  Possibilities include Information Server, DataMonitor, SSRS, etc.

sabine2468

thank you very much but can i connect to sql database using c-scripting if i want to use the second solution.

 It is possible to connect to the SQL Server database from C scripting.  However, it is considerably easier to connect to the database using MS ADODB objects and VBS, so that is how I have done it.  See Example: Configuring a Database Connection with VBS for an example of using ADODB in VBS scripting.   If you are trying to access tag logging data, you will need use the WinCC OLE-DB provider (part of Connectivity Pack) to unpack the tag data from the BLOB that is it stored as in the DB.  See Export of archive data using the SIMATIC WinCC/Connectivity Pack (OLE DB Provider).