• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Cost of product on last date received.

Using Crystal reports 2008.  data is simple lists of items received over last year.  Columns include item, Qty, total cost (no per item cost so must divide), and date received.  Group 1 is by item.  I can show the maximum date for the last date recieved as well as the least and most paid in the group header.  How do I show the cost per item for the last date received?  Thx
1 Solution
You can sort by date ascending.
The record in the group footer will be the last date so just show the price.

BillTantAuthor Commented:
Didn't include getting last line into Footer.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now