My main report is an order acknowledgement. It contains a subreport which looks at an audit file and returns the time the order was last changed. The audit file could have any number of records for each individual order, but I'm only interested in the latest record.

I can display the subreport on the main report and it's linked by order number. Everything works perfectly.

The problem is that I want to select only those orders that have had changes within the past 30 minutes (for example). I can share the variable from the subreport (with the time calculation) onto the main report, but I can't filter the main report to select those records.

Any suggestions on how to accomplish this? I can't link the audit file directly onto the main report because it causes duplicates for all the line items on the acknowledgement (because the audit file can have multiple copies of the same order number).

Thanks for the suggestion. This will be my first stored procedure but I will give it a try.   

Good suggestion. I did get it to work out but I ended up doing it a bit differently. I wrote an SQL statement and used it as a command. I'm not sure if this is the most efficient way, but it worked for me. I have an IBM iSeries Server. My statement in case anyone else needs it as an example:

SELECT ROW_NUMBER() over (partition by tb.ordn40 order by tb.adat40, tb.atim40 desc) as COUNT, tb.cono40, tb.adat40, tb.ordn40, tb.atim40

FROM osld1f3.oep40a as tb

WHERE tb.arct40=2 and tb.aprg40='OE340' and tb.actf40<>'X'