Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Standard report script

Created by: SRB2677 at: 6/24/2009 6:38 AM (10 Replies)

Rating (1)

Thanks 3

Result pages:: |; 1 | 2; |

11 Entries

Entries per page: 10 | all

6/24/2009 6:38 AM	Rate (0)
SRB2677 Posts: 16 Rating: (0)	Hi, Any one have standard report script in either in "C" or in "VB". I have to prepare the performance report for machine in following format. 1. machine working hour report (per shift / daily / monthly / annualy) 2. machine tonned conveyed report ( per shift / daily / monthly / annualy) Kindly do the needful Regards, Sunil
SRB2677 Posts: 16 Rating: (0)
Suggestion To thank Quote Answer

6/24/2009 10:58 AM	Rate (0)
rit03 Silver Member Joined: 6/13/2006 Last visit: 2/11/2023 Posts: 341 Rating: (24)	I would recommend you to calaculate all this data (per shift / daily / monthly / annualy) in PLC and use as a Tag in WinCC and then arrange nicely this tag on standard print layout and then use function printjob to print your report. See WinCC Online Help for more help on WinCC Print Layout and PrintJob function. regards, rit03
	Last edited by: rit03 at: 6/24/2009 10:58 AM
Suggestion To thank Quote Answer

6/24/2009 12:00 PM	Rate (0)
UMENCHO Diamond Member Joined: 3/21/2006 Last visit: 12/2/2024 Posts: 10229 Rating: (1181)	Hello SRB2677, Also put "report script" in search filed here and you'll find a lot FAQs. For example: What options are there for the output of a message sequence report? Regards, Hristo Mihalev

Suggestion To thank Quote Answer

6/24/2009 12:03 PM	Rate (0)
SRB2677 Posts: 16 Rating: (0)	Hi, If we calculate these data in the PLC, thent PLC gets loaded and system gets malfunctions. instead of this can you suggest any Global script in which we call these tags and arrange in the form of Reprts in Excel or in Access. Regards, Sunil
SRB2677 Posts: 16 Rating: (0)
Suggestion To thank Quote Answer

6/24/2009 2:34 PM	Rate (0)
Nil96 Posts: 325 Rating: (14)	Hey Sunil, When we started using PCS7 or Wincc for the first time, we used the Tag Logging where in for each tag we specified the Acquisition at a desired rate and then Archiving say every hour or every 8 hours or every 24 hours. With this we made sure that the Logging happend as per what ever we designed for ( hourly, shift, day). When it came to report, made use of the Report Designer-->Layouts. Here we can define the much needed view in which the report has to be viewed. U can choose this from the runtimeview in the report designer. Well all this works fine. But at times, we found that this gives kind of erratic data. So now a days we are doing the above using scripts. We developed modules like Logging, Viewing and report display. All these modules are developed in VB and we use Global C scipts to trigger the logging. Say every 1 minute we trigger the module called logging and at the end of hour it stores the values in the specified file in binary format. Like we use triggers for shift & day. For viewing, u can use the microsoft date & time and the same can be passed to viewing module which will extract data & the same can be stored in some excel file. After this u can use the WinCCWebBrowser to display the excel file. Hope this is clear. Regards Nil
Nil96 Posts: 325 Rating: (14)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Red Rebel

6/24/2009 6:21 PM	Rate (1)
dilipan_c Posts: 34 Rating: (2)	Hi Wincc comes with SQL server In that u can create ur own database, and the required tables like shift,monthly Use the Global VB script to send the data to SQL Usage of SQL is advantage becoz it comes with Wincc, for MSaccess u have to buy the MS office professional Use the Excel to import the data from SQL via by VBA using ADO connection Or u can use Visual studio 2008 to generate EXE for the report which is very easy We are using this technique for couple of years and found satisfactory regards dilipan
dilipan_c Posts: 34 Rating: (2)
Suggestion To thank Quote Answer
This contribution was helpful to 2 thankful Users krishna143 #Automator

6/25/2009 5:45 AM	Rate (0)
SRB2677 Posts: 16 Rating: (0)	Hi Nil, Do have any project backup which is including the the Reportyou are talking. if you have any kindly send it to me on sunil.bhilare@siemens.com Regards, Sunil
SRB2677 Posts: 16 Rating: (0)
Suggestion To thank Quote Answer

6/25/2009 5:53 AM	Rate (0)
SRB2677 Posts: 16 Rating: (0)	Hi Dilipan, Thanks for your reply, if you are already using it then that's fine. can you send me the backup of working project for my reference. i am not very good at SQL. i will appretiate if you send it to me on sunil.bhilare@siemens.com Regards, Sunil Bhilare
SRB2677 Posts: 16 Rating: (0)
Suggestion To thank Quote Answer

2/10/2010 9:39 AM	Rate (0)
segan Posts: 60 Rating: (2)	Hi, Is there any sample of the above mentioned report format or any working examples. I'm not good in SQL and database. I'm a beginner for scripting too.Waiting for your replies.
segan Posts: 60 Rating: (2)
Suggestion To thank Quote Answer

1/23/2012 8:58 AM	Rate (0)
Eng.Abdo Posts: 99 Rating: (0)	Dear Dilipan, is it possible to get a sample of the mention SQL Service Report, since its very helpful to know about it thanks
Eng.Abdo Posts: 99 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

WinCC Scripting

Follow us on