Good morning,
I have developed a report that is comprised of a main report with only one field (event number) located in the page header along with some text boxes for the header. The report is grouped by event number but the group header and footer are suppressed. There is also a page footer which contains three fields (event number, event date and event number combined with the print date and time).
There are seven subreports that all link back to the event number. The subreports could contain data about persons, items or notes related to the event. For each subreport, if there is no person or item or note, that specific subreport is suppressed.
The report runs every hour and looks for all new events entered during the prior hour, using the following selection formula:
({event_entered_datetime} in dateadd("n",-60,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))) to
dateadd("s",-1,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))))
This works great if the persons, items or notes are all entered the same hour. However, sometimes, a few days later we discover another person or item is involved in the event and the person or item is then entered.
In those instances, I want to print the spplicable subreports with the main report header and footer. However, my main report is looking only for events entered during the prior hour whereas the event may have happened days ago, but the person was just added to the event during the last hour.
Does anyone have a suggestion as to how I can accomplish my goal?
Thanks!
PS - Sorry if this was not well explained. It makes total sense to me, but I've been working on this report for a month hahaha.
I have developed a report that is comprised of a main report with only one field (event number) located in the page header along with some text boxes for the header. The report is grouped by event number but the group header and footer are suppressed. There is also a page footer which contains three fields (event number, event date and event number combined with the print date and time).
There are seven subreports that all link back to the event number. The subreports could contain data about persons, items or notes related to the event. For each subreport, if there is no person or item or note, that specific subreport is suppressed.
The report runs every hour and looks for all new events entered during the prior hour, using the following selection formula:
({event_entered_datetime} in dateadd("n",-60,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))) to
dateadd("s",-1,datetime(currentdate,time(hour(currentdatetime),(int(minute(currentdatetime)/60)*60),0))))
This works great if the persons, items or notes are all entered the same hour. However, sometimes, a few days later we discover another person or item is involved in the event and the person or item is then entered.
In those instances, I want to print the spplicable subreports with the main report header and footer. However, my main report is looking only for events entered during the prior hour whereas the event may have happened days ago, but the person was just added to the event during the last hour.
Does anyone have a suggestion as to how I can accomplish my goal?
Thanks!
PS - Sorry if this was not well explained. It makes total sense to me, but I've been working on this report for a month hahaha.