I am trying to create a report in Crystal XI that will only print records where the date in the "end date" field is less than the most recent date for all records. The table is a Business View pulled from a SQL database.
In other words, if I have 100 records and the most recent date for any given record in the "end date" field is 1/4/10, I only want records where the record's date for the end date field is less than 1/4/10. I can do a summary to get the most recent date in this field, but then how do I use it as part of the selection criteria?
Thanks for any help you can provide.