I have a parent table named order and a child table suborder where each order contains multiple suborders
I created a report that shows all orders and suborders grouped by OrderID.
I need to show the total number of orders., I used the function count(OrderID) in the report header but its showing me the total number of records in the report query which is count(SubOrderID) instead of count(OrderID).
What am I doing wrong?