Using Grouping to identify duplicate records
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20141
Printed Date: 18 May 2024 at 2:20am
Topic: Using Grouping to identify duplicate records
Posted By: mtparki
Subject: Using Grouping to identify duplicate records
Date Posted: 21 Oct 2013 at 11:54am
I'm using Crystal Reports XI.
I'd like to create a report to identify duplicate records in a table and show the userid that created the most recent duplicate record.
At the moment I'm grouping the records by item_name and doing a count to show the records with duplicate item_names. However, I'd also like to display the userid of the record with the most recent date.
I know how to display the latest date in the grouping, but how do I get the corresponding userid?
Any suggestions?
Thanks
|
Replies:
Posted By: kostya1122
Date Posted: 21 Oct 2013 at 12:17pm
go into record sort expert in report tab
and add your date field with descending order.
|
Posted By: mtparki
Date Posted: 21 Oct 2013 at 3:28pm
I should have mentioned that I'm suppressing the detail.
I know how to display the latest date in the grouping, but how do I get the corresponding userid to also display in the grouping?
|
Posted By: kostya1122
Date Posted: 22 Oct 2013 at 7:00am
this should have worked
you just place the userid and the date into group header.
have you tried it and didn't work?
|
Posted By: mtparki
Date Posted: 22 Oct 2013 at 12:48pm
I understand now.
Yes, it is working, although I have to do date ascending to get the latest date to show.
Thanks a lot.
|
|