Need a help in a Report!!

Becka

Hi everyone!
I have a problem. I wanna view information from tables: Registered Whse. Activity Hdr. and Registered Whse. Activity Line. So, when a header appears with it's lines, for example if there's two identical Item No._s with a different Quantities actually there's two line in a table for that items.. and i wanna just sum up quantities and make this record one on a report preview.... So um.. IF any ideas just help..
Thanks a lot!

DaveT

Hi Becka,

First of all you will need to add a key on "item no." in the Registered Whse. Activity Line table. Then you can sort your dataitem by this key and set the item as a grouping. Then use the groupfooter section to print on change of item. Your problem is probably more complex that this but it's the normal way for summarising.