WinCC Unified Comfort Panel: create reports on the panel

In this Video I show you what you need to consider when using reporting on the Unified Comfort Panel. There are 3 points you should consider:

1. It exist a user on the Panel
2. An trusted certificate from the panel to connect Excel
3. A SD Card (with FAT32) is insert in the Panel

What does the error message "service or database initialization failed" or "template files is invalid" mean and how to fix it

00:00 Intro
00:08 preconditions
00:34 user
00:59 certificate
03:57 missing SD Card (service or database initialization failed)
06:31 template files is invalid
07:42 final tip

why FAT32?

#DerHecht #WinCC #Unified #TIAPortal

[jancialmeidachaves]

Hello Mr. Hecht, your videos have helped us a lot. Because there is not much support material for this product.
Regarding the process, I can do the process online, I can install the certificate correctly, everything works perfectly,
but in an attempt to do the offline reporting, when inside the physical Ihm, I select to add the template, it just doesn't show up.
I tried to create several templates, but to no avail. I'm on firmware version 18, and even then the error persists.
Is there a specific certificate to create offline repporting or does this one you created meet both types?
The process I'm referring to is the same one you do at instant 4:40 of your video.

[marcbayarri]

Hello Mr Hecxht,
First thanks a lot for your all videos that help me a lot for my job. 🙂
I try to generate report on a panel MTP700 with TIA V19 and i'm not able to see the template made with excel on my panel.
I have the same message that you have at 5:01 on your video and don't found the template as you have at 5:24.
It seems that my SD card is not read biut when i open my File Browser i see the X51 and several folders and files.
Can you help me please.

Best regards

[marekhrivnacky]

Deat DerHecht, i am trying to report 5 tags and every try is ended by empty report. I tried setting the time range according to the tag, relative time, etc. None of it worked and the report is always empty. I would like to check the saved data, but I don't know what software to use for checking. Can you help me please? Thank you.

[MercutioX]

Hallo DerHecht4.0 bin momentan an meiner Techniker Arbeit mit Unified v18 muss diese aber allein ohne Unterstützung machen. Somit hätte ich da ein Paar fragen wäre es möglich Kontakt aufzunehmen ?
Grüße
Mathias

[juergenhelmich]

Dear Hecht,
first of all many thanks for all your videos! If you change over from WinCC Advanced to Unified your the MAN to watch on Youtube!

I have managed all the steps you recommend, but still have not establihed the connection in Excel.
"No connection to server..."

Any further recommendations for firewall settings, user rights, certifcates would be helpful.

Best regards,

Juergen

[mathiasterhorst]

where i can get the programm for excel? I dont have the WInCC Unified in my Excel.. Sry for the stupid question...

[sezginzehir]

Hello, I am grateful for your shares. How can a report be created to keep alarm records?

[MrMecho]

Good day,
Have you tried reading string tags in the report template? Everything looks ok while creating the template and all string tags are read normally. As soon as the template is uploaded to the panel, string tags can not be read and they stay as blank in the report. Also I found that there is a problem with updating tag values. All tags in the unified panel are "Cyclic in operation" and when generating the report, the values are not updated. I need to read all the tags manually in a script before generating the report in order for this to work. There is no way to set tags as "Cyclin continuous".
Best Regards

[matteodigiacomo]

Good morning,
When I open Excel, under "WinCC Unified Reporting" instead of the User Login, I get an error that says "add-on error" and under "the content is blocked because it is not signed by a valid security certificate"

[immofreund]

Hello, runs it only with Office 365 or also with Office 2016?
Thanks