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).