Skip to Content
0
Former Member
Jul 30, 2009 at 06:25 PM

Question about sort technique

14 Views

we have a report that shows a list of contacts and we have an sub-report that displays (1) one field max(history completed date) so we can see that last time the contact was talked to. The issue is: if we want to have a sort parameter sorts on the max(history completed date) field. How would we do this?

1) pass the field value from the sub-report to the main report?

2) don't created a sub-report, create field value in the main report using sql

Please comment on the approaches above or any other methods that I might not have thought of.