Need help with getting the last history line

building reports desktopintelligence
1

I need to get a report with the last shipment history line.
Now we have a DB with shipments and each one has multiple history lines.

How do I get the last line ? I do have timestamp for each history line.

Help would be appreciated.

Thanks,
Eran.

eransh10 (BOB member since 2008-09-09)

2

Eran,

This example should help you.

Cheers,
Mark

3

I am trying to build a report that will return the last history line for a UPS shipment (we have UPS info in our DB and we store it per shipment we have).
Currently this is my table:

Shipment # | history date| history text

I need to get per shipment # the last (MAX) history text.
Using calculation doesn’t work - it only returns the max history line even if I ask it to calculate this line per shipment #.

Any other ideas ?

eransh10 (BOB member since 2008-09-09)