Grouping in Report - counting no of headers

[wilkob]

I have made for our shipping department a report that shows the number of pending orders (+items) ready for shipment. I have based my report on a query that shows:
order no , order item, status, pcs ordered, pcs balance

Via the report wizard I have grouped on the order no, and then sorted in the detail on the orderitem.
So far so good.

Now I would like to have some totals on the end of the report for the number of orders and the number of items that appear on this report.
Can someone tell me how I could "count" the number of order no or headers?

I was thinking of some kind of formula in the report trailer for this????
Is that possible at all?

 

[Michael J Ross]

In the report footer add a text box and set its Control Source to =Count([order no]) for the number of orders and add another text box for the number of items with the Control Source =Sum([pcs ordered])

 

[wilkob]

I have added added the count [order no] but this doesnt'count the order no but the number of items for each order.

I have grouped on Order No and then added a footer where I added the text box (see my attachment)

 

[Michael J Ross]

Ok, sorry yes I didn't think it through, that will happen.

One way to achieve what you want is to create an unbound sub report based on a query that calculates the number of orders placed and put it in your report footer.

I think this will be infact 2 queries, the 1st a group by on order no field only based on the query that populates your main report, the 2nd query based on the query you just created will be a count of the order no.

Use the tollbox to add a subreport base it on the last query and make sure you choose none when it asks what you what you want it to be bound to from the main report. Place this in your report footer.