Print Page | Close Window

retrieving last row from a group

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5493
Printed Date: 04 May 2024 at 11:30pm


Topic: retrieving last row from a group
Posted By: CRMSFDC
Subject: retrieving last row from a group
Date Posted: 12 Feb 2009 at 1:29am
Here is sample data abt hw exactly i want it ...
Name
A            10 1/11/06
A            12 2/20/07
B            19 1/11/06
A            15 1/1/08
B            12 1/11/09
A            18 1/1/08


Now i hve grouped them according to there names . i just want to display below value in crystal report ...



currently my report displaying only last row of group (in group footer)(suppressed detail section) like below.

A    18 1/1/08
B    12 1/11/09

but I want to display not only last row of group but also if other record also has entries(one or more) on same date belongs to same group.

like below,
Group no posting date
A    18 1/1/08
A    15 1/1/08
B    12 1/11/09

How to implement?
Help me out!



Replies:
Posted By: despec99
Date Posted: 12 Feb 2009 at 1:19pm
If I'm understanding you correctly, try grouping by name AND by date.

David



Print Page | Close Window