Crystal Reports - Distinct field entry (not record) from select
Posted on 2006-10-30
I have a minor problem I would like help with.
I am writing a crystal report that shows how records are moved to a particular area per hour. I am using a table that gives me the record number and the area it is in. The table has an entry added whenever something changes in the record so there will be multiple entries under the same area.
I currently have the report doing a distinct count of the record number in an hourly group, which works fine except that if the record gets updated later on it is getting counted again (in another hour) as the distinct count is only relevant to the hourly group. I want a way to bring in only one (the first ideally) record that shows the area in question per record number.
My select is currently by date range and record area.