General information
Category:
Reports & Report designer
>I have two tables that are related by stock number: stockdesc and puritems. The stockdesc table has the stock items described. Puritems includes all of the stock items that are on purchase orders. I have a report that prints out the stockdesc.number, stockdesc.description, stockdesc.onhand, and the puritems.ordered, puritems.delivered. However it only prints out the first purchase order found. I want the report to sum all items that are still on order for that particular stock number and display those numbers on the report.
>
>How do I accomplish this? Thanks in advance.
Assuming that you are opening the tables in the report data environment:
1) Set the relationship to One-to-Many.
2) On the report, set up a group on stockdesc.number and move the controls out of the detail and into the group.
3) Set the calculation method to Sum for puritems.ordered, puritems.delivered through the properties for each field.
I think that should do it.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only