Report Generator doesn't work in RT
Hello everybody,
I have a problem with the Report Generator and I donÂ't know how to solve it. Maybe anybody has any idea...
In my project I have an archive where different process data are saved. The archive is started with a trigger and the save cycle is each 2 hours. With this configuration the safekeeping period is for 14 years.
What I need to do is to have the sum of values from the process of one day, one week and one month.
The first thing I used was a following archive with the save cycle 1 day, another following archive with 7 days for saving cycle and the last with 1 month. The problem is that the client wants to see the actual sums too in one day, for example, he want to see today the sume of values since 7 oÂ'clock in the morning. With the following archives I can to see the values once the archive is closed. I made a report with a time filter for one day (for the daily report), but with this configuration I can only see the sums from yesterday and the days before, and I cannot see how is growing the sum today.
I have tried to solve my problem with a report generator instead the following archive. What I do now is the sum in the report each time new data is scanned. I read the values from the archive and I make the sum in the cells. Then, I have a time filter in each report, for one day, one week and one month. That allows me to choose which day, week or month I want to show in the report. I need to use all the cells in the report because the amount of data is too big.
In RT, the actual day is showed without problems, but when I try to read the data from another day (using the time filter) the report is very slow or simply doesnÂ't work. The reports for weekly and monthly data show symply nothing.
Does anybody know what is the problem? Maybe is because the report cannot work with all the cells when the amount of data is too big?
I really need to solve this problem as soon as possible, so I would be very grateful if anybody could give me an answer or maybe another solution.
Thank you very much,
Kind regards,
Luc
This is a migrated post! Originally posted on 30.01.2014 by user luc. Please be aware that information can be outdated.
Disclaimer
This document governs the use of our Community Forum. By registering and using the platform, you accept these conditions.
The COPA-DATA Community Forum serves to encourage the exchange of information and experience about the zenon software between forum users respectively zenon users.
Please mind that any published information on the Community Forum is the subjective opinion and view based on the experience and the level of knowledge of the author. COPA-DATA does not overtake any responsibility for the content and the accuracy of the shared information.
Users of the Community Forum are encouraged to share only well-founded experiences and to point out any risks associated with the implementation of proposed solutions to problems. COPA-DATA at its absolute discretion, reserves the right to moderate the forum. In this connection COPA-DATA may remove any information containing false facts, potentially dangerous solutions, bad language or content that may insult, degrade or discriminate others. COPA-DATA may block a non-complying user from forum access if the user violated this provision.
COPA-DATA reserves the right to change this document from time to time at own discretion.
Ing. Punzenberger COPA-DATA GmbH
Karolingerstraße 7b · 5020 Salzburg · Austria
www.copadata.com