I have a pretty basic report (sample below). There are no append rows..... everything is a detail line, except for the header row....obviously. My trap for the detail line is using the Date[/I] column. The only column that could wrap to a second line is the Message[/I], in which I have the End Field On[/I] option set to End of left Justification[/I]. Everything works fine.
Now for the tricky part where I need a guru's assistance. I need help in creating a calculated field to determine how many minutes have passed since the previous detail line's time. All time is Military; however, no colons exists, but that's easy to place in there and convert to date/time format. I tried the ol' guru trap by defining the detail line again as an append in hopes to create a second time field and simply calculate the difference between the two, but that didn't work..... or I didn't do the guru trap properly.
In the sample below, there's a detail line where the time is 0349 and the previous detail's time is 0024. I need a calculated field that will give me a value representing 205 minutes have passed since the last event message.
DATE: TIME: TYPE: MESSAGE:
08/19/10 0004 CLOSE DAY Auto Close Day posted batch RAD #324 08/18/10
08/19/10 0022 BATCHES Auto Batch PHA.N.LIVE (#325) for 08/18/10: Retrieval
08/19/10 0022 BATCHES Rejection Auto Batch PHA.N.LIVE has been created
08/19/10 0024 CLOSE DAY Auto Close Day posted batch PHA #325 08/18/10
08/19/10 0349 CLOSE DAY 08/18/10 close waiting for ADM.N.LIVE Auto Batches
08/19/10 0349 BATCHES Auto Batch ADM.N.LIVE (#326) for 08/18/10: Retrieval
08/19/10 0350 CLOSE DAY Auto Close Day posted batch RC #326 08/18/10
08/19/10 0350 CLOSE DAY Auto Close Day posted batch ERSUN #22 08/18/10
08/19/10 0350 CLOSE DAY Auto Close Day posted batch ERSUN #56 08/18/10
I use Monarch 10.5 Pro and DataPump 10.5 Standard. Any suggestions on how to accomplish this task?