Hi
I have a particular set of work orders and different dates in whcih the work orders were generated and their corresponding summary.
For eg:
WO Date Summary
123 9/11/12 abc
123 9/12/12 bcd
123 9/13/12 efg
1234 9/1/12 xyz
1234 9/2/12 asd
I want the output to look like (select the sumary for the latest date of each work order)
WO Date Summary
123 9/13/12 efg
1234 9/2/12 asd
I was able to create a variable for date to chose the latest date
date1 = max(date) in ([WO])
but after that when i pull the summar along with it I am getting max of date fields but all summary,
how would you suggest doing it? Do I need to create another variable for summary? If yes how would you create a variable for summary?
I am using BOXI 3.1 SP3 FP3
Cheers!