That worked thanks!
I hope you don't mind a couple more simple questions
First, I'd like to display the last used date. I can get this by displaying the Max @flag field but that leaves me blanks for the parts with no dates. When exported to excel they show up as 01/00/1900. Which is fine for when we do export it, but when printed out of crystal they are all blank. I tried a formula like this...
if isnull (Maximum (
{@@flag}, {parttran.partnum})) = true then
"xxx" else
Maximum (
{@@flag}, {parttran.partnum})
I was hoping to put something in the nulls like "never" but it doesn't like that. Am I on the right path here?
Second, I mentioned the costing data I have. It's so we can tell how much value this old inventory is worth. I bring in the current on hand QTY and have a formula adding the material, labor , etc... to give me the unit price. I then have a formula multiplying them together for my on hand value. When I then summarize the on hand value to get my report total I get the total for all detail lines returned instead of just what is displayed. We know we have a lot of old inventory but not 1.5 trillion worth! lol
Any help is greatly appreciated!