Skip to Content

Filtering Other fields in group footer based on Record count in Crystal reports 2013


I have a requirement to display previous and latest receipt dates for comparison from a date field and display them as 2 separate fields in group footer(group applied on Item - each item have multiple receipt dates, so applied grouping on Item and displaying only latest 2 receipt dates for all items). I achieved this somehow,(by creating runningtotal field for latest & previous date) but the thing is i have to get other fields such as Order number, purchase Price of these previous and latest receipts and display them in the footer as in the picture attached.

Like, for Previous Order Number, i need as below:

Previous Order Number = Order number where (Date=2nd latest receipt date) which is the second row value of each group.

Kindly let me know if someone had this kind of requirement in crystal report.

ima1.png (11.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.