Display previous operation on Material Tag in SSRS


(Fred Meissner) #1

I am trying to display the previous operation on the Material Tag. When the Material Tag is printed at the end of an activity, it displays the operation that the Material Tag and related parts will be going to next. I would like to display the operation that is before that (i.e. the operation where the Material Tag is being printed from).

I tried to set up my query in SSRS like this: Previous Operation in BAQ

However, I am getting a syntax error and think it might have something to do with the RDD only having one JobOper table (I need a second one for the subquery).

Any advice?

(Dave Olender) #2

Mr. Fred: I added a BPM to intercept the “Report Quantity” and I am forcing the “Next Opr” field to hold the Current operation.

That way your RDD will be able to display the correct Op codes and descriptions.

I went round and round with Epicor on this one - Epicor changed their logic and I tried to get them to change it - no surprise - my whimpers went in-noticed.

(Fred Meissner) #3

Thanks for the reponse Dave. I actually ended up solving this myself.

I removed the relationship between MtlTags.OprSeq and JobOper.OprSeq, then passed the full list of JobOper.OprSeq to a subreport where I sorted that it in descending order, set JobOper.OprSeq to be less than MtlTags.OprSeq, and then used a Top N = 1 filter to only choose the last operation before the MtlTags operation.

If anyone else wants to implement this, I would happy to go into more detail.

(Jeremy Jones) #4

I could use more detail. I’m also trying to get the previous Op but it keeps using the current.
I keep getting 300 when I select TOP 1 in the SQL Query and I get the same Op as the query Op when I use it in a BAQ between just LaborDtl and JobOper.

(Jeremy Jones) #5

Any way I could get that BPM ?

(Dave Olender) #6

Mr. Jeremy: I will try to find it - it’s been a while.


(Adriano Salvatore) #7

Looking for this as well. Were you able to find a solution?

(Jeremy Jones) #8

Any luck with finding that?

(Dave Olender) #9

Mr. Jeremy: I found the EndActivity BPM – could not find the Report Qty BPM.

(Dave Olender) #10

Found the Quantity BPM. Exact same logic as the EndActivity – just uses a different method: