Set all trends for all displays in ProcBook to use same start and end time

Discussion created by cjrancur on Feb 12, 2010
Latest reply on Aug 4, 2011 by cjrancur

I recall a demo showing that all Process Book trends within a given display could be selected and set to the same start and end time.  I don't know if there is such a handy tool included for all displays in a Process Book.  I'd like to find or build one.


I am considering making an initial page in the ProcBook, and putting 2 datepicker controls on it, one for start and one for end.  Then connecting all trends in the book to get their start and end time from this.


The reason I want this is that I must do a monthly report of certain process events and control status.  The report goes from 9 am on the 15th of one month, to same time on the next month.  If the 15th falls on a weekend or vacation, or even if I'm working on the report in the afternoon of the 15th, I'd like to see only the data for the period I'm reporting on, so that I don't muddle the report with things happening earlier or later.  Every month, I go through about 30 trends and update the start and end times.  Since I do it monthly, it makes sense to automate this, if I have a few minutes to do it.


I have built a good datalink spreadsheet that gets most of the data, but I don't like datalink trends.  Maybe they are better now, but years ago, they'd cause datalink to crash, and you couldn't do as much with them as easily, like zoom or use a data cursor.  I'd rather use a process book trend, because of all the nice features OSIsoft provides for PB trend.


If there is already a built in way to do this,  please let me know.  I'm starting to build vba code to do this, but if it's not necessary, I'd rather use an OSIsoft prebuilt method.