Previous & Next Resource for Custom Priority Dispatch Report


(Jeff Lehr) #1

Vantage 8.03.410 / Crystal

I have written a BAQ Report to replace the default Priority Dispatch Report. I would like to know if there is a way to find the “Previous” and “Next” Resource ID’s to list on the report?

Jeff


(Bruce Ordway) #2

Just off the top of my head, without knowing anything about your custom report
I’d think you’d want to pull JobOpDtl into your BAQ/Crystal (if you haven’t already)
and then use subreport(s) to pull next/prior into your main report?
i.e. find the next - JobOpDtl.OprSeq JobOpDtl.ResourceGrpID
and find the prior - JobOpDtl.OprSeq JobOpDtl.ResourceGrpID