Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 20 Mar 2008 at 2:22pm
This is a tough one. As much as I try to avoid subreports, you're probably going to have to use one - especially since the data for the main part of your report is probably sorted and grouped, but not in DOB order.
Here's what I would do:
1. Create a small subreport to put in the header. Use the same table as your main report. Link to the parameters (if any) on your main report so that you have the same selection criteria for both.
2. Sort the subreport data on DOB, Ascending.
3. Suppress ALL sections of the report except one Report Header. In that header put the Name and DOB fields.
This will only display the first record, which should be the oldest person because the data is sorted by DOB.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
