Printing the latest updated record

[kringli]

I am pulling gross margin information. There is a process we run that updates the costing information. If there is a change then a whole new record is created and both show up on my report. I only want the latest updated one. Any ideas??

 

[lbass]

If there is a date field, then go to report->selection formula->GROUP and enter:

{table.date} = maximum({table.date},{table.item})

...assuming you mean the cost info per some item, and that there is a group on item.

-LB

 

[kringli]

What if there isn't a date field? Do I just need to find a table that has one?

 

[lbass]

How do you know what the newest cost information is? If not by date, is there a number that is sequential?

-LB