I have a report with data items that can/will change their 'state' over time. I need to only show the last 'state' of these data items.
Example: Report results with no filter (state 1 ends in 00, state 2 ends in 01, etc.)
abc12300
abc12301
def12300
ghi12300
jkl12300
jkl12301
jkl12302
The final report with filter should only show:
abc12301
def12300
ghi12300
jkl12302
with the help of trim fns we can get that data items alone.. try it
Take the max of the states. For example, MAX([State])