I am trying to duplicate a report I had in Vantage 5.2 for Vantage 8.03.407A which shows any operations that did not get properly closed on a job. We were able to do this in Report Builder using Calculated fields and Aggregate fields. We haven't been able to find a way to create a BAQ to duplicate the behavior. The trick is not showing operations past the last completed operation.
So, in words, this would be the query:
Return open operations for all open jobs where the operation sequence is less than the last completed operation sequence for the job.
Like I said, we had this report in Report Builder and I have done the same query in SQL against our data warehouse using a sub-query.
Any insight would be greatly appreciated.
Thanks,
Jim
So, in words, this would be the query:
Return open operations for all open jobs where the operation sequence is less than the last completed operation sequence for the job.
Like I said, we had this report in Report Builder and I have done the same query in SQL against our data warehouse using a sub-query.
Any insight would be greatly appreciated.
Thanks,
Jim