Display the most recent child record in a report 1

[lnordstrom]

Hello,

I'm using BO XI Deski. I have a report where a main record has multiple child records (notes) that I am putting in the same report. I would like only the most recent child record to be displayed on the report.

here is how the records are structured:

Main Record Case:
Case.number, Case.Name, Case.Client, Case.DateOpened

Each main case has many child records, in this instance, notes. The report now looks like this:

CaseNum CaseName CaseOpened CaseNotes CaseNoteAdded
Case1234 Smith v. Jones 1/25/2010 Note 1 1/25/2010
Case1234 Smith v. Jones 1/25/2010 Note 2 2/25/2010
Case1234 Smith v. Jones 1/25/2010 Note 3 3/2/2010
Case1234 Smith v. Jones 1/25/2010 Note 4 7/5/2010

I would only like one row to appear grabbing Note4 as it is the most recent. The notes are updated weekly and this is a weekly report I'm creating.

Thank you!
Lisa

 

[lbass]

You are posting (both posts) in the wrong forum. Please repost in forum767 or forum149.

-LB

 

[hilfy]

Actually, as this is a Deski report and not Crystal, it really needs to be posted to the Business Objects solutions forum.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

Thanks, Dell, I missed that.

-LB