Just hoping to get some ideas. Developing a report that has basically some part master info (number, description, Std Cost, etc). I need to pull in from my Purchase Orders or Receipts table the most recent purchase date, and the most recent purchase cost as well as an average cost based on an input parameter (calculated over the last X days based on a parameter). I was going to create a subreport but wasn't sure how to get the latest record for Purchase Date and Cost. Any thoughts?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Get Latest date and Cost
- Thread starter GCL2007
- Start date
If you group by part number or whatever, you can then suppress the detail lines and show the values you want in the group footer. If you sort by Purchase Date then it can be the last record in the group and you can show its values in the group footer.
Subreports are much less efficient, each does a separate access of the server.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Subreports are much less efficient, each does a separate access of the server.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 - Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question