Top three rowsa

[anish95]

Hi:
I am trying to run a report patients and their recent three lab values, group the report by unit and under group I want to see only three recent values for each patient.
my report should look like this

Patient Name Date Lab Value
Nursing Unit 1
Patient 1 5/21/2010 54
Patient 1 5/20/2010 50
Patient 1 5/19/2010 49
Nursing Unit 2
Patient 2 5/20/2010 35
Patient 2 5/20/2010 45
Patient 2 5/19/2010 40

I really appreciate your help and time.
Thanks

 

[lbass]

Group by unit and then by patient. Sort by date descending. Then insert a running total {#cntwingrp} that does a count of any recurring field, e.g., patientID, evaluates for each record, and resets on change of group: Patient.

Then go into the section expert->details->suppress->x+2 and enter:

{#cntwingrp} > 3

-LB

 

[anish95]

Thank you very much lbass. It works fine.