I have an interesting challenge where I have an Entry ticket (Entry Time stamp) for example 12/12/2013 08:05:00 am and an Exit transaction (Exit timestamp) 12/1/2013 5:05:00 pm - (Duration 9Hrs) and I am trying to figure out a way to count the hours that this ticket can be counted as 'Occupied'.
So I will have 24 Hourly counters (datetimetoseconds) that run thru each transaction and check the entry time then each Hour and an add a count until it reaches the exit time.
My solution initially started with the approach to have Hourly schedules run and look at all tickets that are currently open, which I got to work perfectly but this leaves me with other challenges like for example I can only process data since the day I started the scheduling process.
Looking at the new approach would want to look at all available data.
Thank you James, by grouping by the Hourly formula set by the excel sheet, and selecting the previous day transactions(exit times) I'm able to show all the transactions under each hour group. I then conditionally
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…