Weeding out multiple values in report

[ivow]

I have a query that collects objects OrderID, Shipping Cost and Items.

The relationship between "OrderID" and "Shipping Cost" is a "one to one" relationship. And the relationship between the two above and "Items" is "one to many".

So, when I create a report I get this...

OrderID Shipping Cost Item
23 3.00 1 Red Bike
23 3.00 1 Blue Bike
Total 6.00

The Shipping cost is the overall shipping cost for the order and it gets repeated every order. How could I get the shipping cost to just show up once per order? Should I break it up in the report or is there something I can do in the query?


Ivo "If it's stupid but works, it isn't stupid."

 

[lhite]

Make sure you have a footer for the ORDERS group. (If not go to VIEW, SORTING AND GROUPING and for your ORDERS section set GROUP FOOTER to YES.) Then, just move the shipping text box from the Detail section of the report to the ORDERS footer. Change its contents from just its name (say, SHIPPING) to a sum formula (=SUM(SHIPPING)). That will not list the shipping charge in the detail section, but should give you a total shipping charge below.

-Larry