SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Report and Total (Is it possible?)

6/20/2009 9:25 AM	Rate (0)
roberto.zeni Experienced Member Joined: 4/9/2009 Last visit: 12/15/2025 Posts: 71 Rating: (1)	Hello I use Wincc 6.2 and I would like to do a report based on table of "User Archive" adding totals of some colums. Is it possible? Ido not want to use external packages!! Thanks

Suggestion To thank Quote Answer

6/20/2009 11:26 AM	Rate (0)
Enigma Posts: 49 Rating: (18)	Hi roberto, please find attached file which briefs you about UA. Basically in UA you can 1.collect the selected values 2. Store them in the database 3. Import and export data in other tools like Microsoft Excel (Here you have it!! ) So, Once raw data is in Excel you can do anything and everything with that But regarding your reluctance to use additional software, i would like to bring to your noticeis User archive is an Add-on package to WinCC... hope it helps!!! Regards, Enigma Attachment User Archives.pdf (190 Downloads)
Enigma Posts: 49 Rating: (18)	Last edited by: Enigma at: 6/20/2009 11:28 AM
Suggestion To thank Quote Answer

6/20/2009 2:09 PM	Rate (0)
CBo Gold Member Joined: 4/5/2006 Last visit: 10/3/2025 Posts: 917 Rating: (63)	Hi roberto, to few information about what you want to do... if you are talking about "WinCC Report Layout" you can put in all data coming from WinCC database...you can configure in Report Layout which archive you want print and select what colum you want print...or read archive on event then store data you want print on internal tags at the and print report with internal tag configured... can you explain with example what you relly need? Regards

Suggestion To thank Quote Answer

6/20/2009 7:08 PM	Rate (0)
uel123 Gold Member Joined: 1/29/2006 Last visit: 1/18/2026 Posts: 451 Rating: (65)	Hey, Roberto! I see 3 possible solutions: 1. Export of Ua in Excell and firther work there, as Enigma proposed; 2. Preparation of Total allready at creation of new record! 3. Some C-scripting programming, when report is prepaired for printing. F.E: - Opening UArchive - Finding records, that fail in desired time span - Going through record and totaliseing of values... - Saving total value in internal tag - Closing UArchive - Prepairing report (in report designer)...... I must say, that there are not many examples for this sort of work on net. Try this: http://support.automation.siemens.com/WW/view/en/15343333 It is a Manual for WinCC options, with example of C-scripting with UserArchives. have fun! uel123

Suggestion To thank Quote Answer

Share this page:

Share this page on...