Posted: 3 Jan 2017 12:46 EST Last activity: 16 Oct 2018 12:03 EDT
Fetching Latest Record for each category Using RD
We have a requirement to fetch the latest record for each category. We have different mail boxes configured, emails received on those mail boxes will be stored in a database table. I have requirement to get the latest Email for each Mailbox. How can we achieve this. ?
I have tried by creating 2 reports.
1st Report : Added MailBox and created Date time columns.
Group by Mailbox and Max(ReceivedDateTime)
which gives me the latest record for each mailbox
2nd Report: Included all the columns which i want and then used a sub report which i created in last step. and the join condition i have given like the sub report and main report ReceivedDateTime and Mailbox should match.
This approach is working fine. But i want to know if there is any other better approach to achieve this.
***Updated by moderator: Lochan to add Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Will this be applicable fo the groups too. I have a grouping in the RD and i need the top record for each group.
When im selecting the ranking option for a RD with summary condition on a column and using for each group in the ranking options and while saving the report the ranking condition got vanished int he rule form itself.