Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Report designer

Created by: michaelf at: 7/5/2006 10:08 AM (12 Replies)

Rating (0)

Thanks 0

Result pages:: |; 1 | 2; |

13 Entries

Entries per page: 10 | all

7/5/2006 10:08 AM	Rate (0)
michaelf Posts: 29 Rating: (1)	hello, I want to make a report with trends. These trendsmust getthe data out of an user archive. is there a way to display data from user archives in a trend in a report? If I use taglogging, is there a way to filter the data? thanks in advance
michaelf Posts: 29 Rating: (1)
Suggestion To thank Quote Answer

7/6/2006 9:36 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	[quote user="michaelf"] is there a way to display data from user archives in a trend in a report? As you have seen, there is no User Archive - Trend control in the Report Designer. I can think of the following to workarounds : 1) Use the Function Trend Control in the Graphics Designer. Draw this control on a PDL and then in Runtime press the Print toolbar button to print the trend. The Print button runs a report job which you can modify if necessary. 2) Use the CSV Provider - Trend control in the Report Designer. This control reads data from a CSV file and plots in on a trend. You will have to export data from you UA to a CSV file, modify the format of the CSV file to suit the requirements of the CSV provider and run the report. Of the two options, I prefer option 1 as it requiresno scripting and a lot less steps. [quote user="michaelf"] If I use taglogging, is there a way to filter the data? The Tag Logging - Trend control in the Report Designer allows you to dynamically pass parameters to the control before the report runs. You do this by checking the Tag checkbox against a specific setting. Assign an internal string tag and write the parameter value to the internal string tag. This value is then passed to the report when it is run. Hope this helps, Salma

Suggestion To thank Quote Answer

7/6/2006 9:38 AM	Rate (0)
balu Posts: 69 Rating: (9)	Hi Michealf, for filtering Taglogging maybe the following link can help: http://support.automation.siemens.com/WW/view/en/23510826 for print Userarchiv Data in a trendcontrolsee reports.pdf in the WinCC Doku chapter 3.5.3
balu Posts: 69 Rating: (9)
Suggestion To thank Quote Answer

7/6/2006 10:01 AM	Rate (0)
michaelf Posts: 29 Rating: (1)	thx for the replys! for the 1st question, i'll try with csv. for the 2nd question, i think i didn't explain quite well. I got some temperatures that I log every minute. With these temperatures I log also an ID. What I want, is to display the temperatures with some ID in a trend. example, I want only temperatures where the ID is 2. thank you greetings Michael
michaelf Posts: 29 Rating: (1)
Suggestion To thank Quote Answer

7/6/2006 10:50 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Hi Michael Can you give me a bit more info on how you are doing this logging ? Such as are you using the Tag Logging or User Archives to log the temperature? and is the ID being logged anywhere ? You cannot "filter" a trend but you can dynamically set the start and end time. So we need to figure out where (if at all) the start / end time for each ID is logged.

Suggestion To thank Quote Answer

7/6/2006 1:19 PM	Rate (0)
michaelf Posts: 29 Rating: (1)	Salma, First I logged with Taglogging every minute a temperature and an ID in an archive. I do thatwith several temperatures and ID. So I have configured 39 archives with a temperature and an ID. They are logging every minute. The problem I see with time is that 1 unique ID is logged in several archives. The ID moves around the archives. A little bit more explanation... I have an application with 39 lanes where a product is placed. Each product has its own ID. Now and then the product must be replaced. The logging of the temperature must be with an ID. For nowI login function of the lanes. I don't see how to log in functionof the IDs, becauseNew ids are constantly made en deleted. So I didn't find how tocome up for a solution, so i see data forsome ID. ThenI made a script that logs the temperaturein an User Archive, where i can define a filter. That works, and i can get out the data in a table, but not in a trend. greetings
michaelf Posts: 29 Rating: (1)
Suggestion To thank Quote Answer

7/6/2006 1:49 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Thanks for the extra info. I cannot see another way to develop your solution (my application development skills are seriously underdeveloped [:)] ). From what you have said of your project, I would have to agree that User Archives is the way to go. It is the simplest way to record discrete data records. Would this suggestion help : create a UA with three columns, ID, start_time and end_time. Then when a new ID comes in, log it as a new record in the UA table along with the start_time. Then when the ID (the product) has left the lane, update the UA record with the end_time. You can then use this UA table to determine the times for a particular ID. These times can be read out and dynamically passed to a trend control. Hope this makes sense!

Suggestion To thank Quote Answer

7/6/2006 4:06 PM	Rate (0)
michaelf Posts: 29 Rating: (1)	Salma, I see your point of logging start and end time of an ID in a lane. Then I know where and whenthe ID has been used. But It is possible to combine data from different archives in a trend? I mean I want 1 trend and not 5. (5 if the product has been in 5 lanes.) For far as i seen, You cannot display User Archive data in an trend, not at runtime and not with a report. That is too bad... greetings
michaelf Posts: 29 Rating: (1)
Suggestion To thank Quote Answer

7/6/2006 4:11 PM	Rate (0)
michaelf Posts: 29 Rating: (1)	Ow, i think it is because its quite hot here, but i find a way to display the user archive data in a trend, my bad... But i don't find how to make a function trend with date and time? In my UA I have a column where a time is written in, but I cannot select these for my X axis or Y axis... greetings
michaelf Posts: 29 Rating: (1)	Last edited by: michaelf at: 7/6/2006 4:18 PM
Suggestion To thank Quote Answer

7/6/2006 4:22 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Oh yes, I have seen this problem. You need to read the datetimes out into tags and then write these to the BeginTime and EndTime of the trend control. Note that the column in the UA table must be set to String andNOTDatetime if you want to use control tags to read the value from the UA. It's actually hot here in the UK too, for once [:P]

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on