Hello Support Team,
We are currently using WinCC OA 3.12 version excel reports. We need to design billing reports in our solution. Is there any best approach to configure reports without using standard templates and without using OLE DB provider.
Requirement:
We need to retrieve the historical data from the WinCC db as per the requirement (firing a SQL query ) and get the information of consumption(probably one dpe - hourly/daily/monthly). And after that as per tariff type like slab wise or time zone wise, we need to calculate the bill based on units consumption. After calculating the bill we need to populate these information on custom template, print the bill automatically in .pdf format and send bill to configure mail ids automatically(Scheduling).
Please suggest a best approach to develop the above requirement in Wincc OA 3.12 platform.
Thanks in advance.