New to CR so I Appoloigize if this question is a little on the basic side, I am headed down the path of trying to create a masive report by breaking it down to lots of sub reports but i am having some issues. The goal is a report that is something like this"
Department      # of "Status*" work orders (WO)
            
----sub report of "Status*" WO by type and count of each

--------sub report of each WO by status and type

* Open Or Closed

so for exammple
Bike Department     34 closed work orders
                    52 open work orders
----
34 Closed Work Orders
     Tire Repair    5
     New Breaks     10
     New Cables     14
---------
Closed Work orders for Tire Repairs
WO # 4569    Bob Smith           2.4 hours
WO # 4575    Bruce Collins       2.4 hours
WO # 4968    Janna Robinson      2.4 hours
WO # 5236    Jason Grant        2.4 hours
WO # 6985    Jerry Garcia        2.4 hours



Sorry for the crazy lay out. I am having a hard time trying to Find out how to do this based on having a hard time explaining it in terms for CR. Thank you in advance for any guidance!!
       

Is it possible to point me to some good resources on how I might pull this off with Grouping? Thanks for you guidance.

I have moved over to Groups but now i have some issues with totals. This is where I am in the process:
Group 1 Department
   Group 2 Status and Count of WORKORDER.STATUS
-this count is a summary if Status and sum as count
      Group 3 Workorder (Hide Drill-Down ok)

At this point all is good. The idea is for group 3 to be clicked on and the all the info for Department+ Status is shown, so when it says:
Trash Department
     Closed             102
     Open               38
Click on Closed and the info for the 38 Workorders will then open.
The issue I am having is when I add to Group 3 like Description so that i now looks like..
Group 3 Workorder and Description (Hide Drill-Down ok)

The Count for Closed and Open change to 98 and 27 respectively. Not relay sure what the step is to make those numbers stick..   the 102 and 38 are the correct numbers based on some other QC reports i have created

do a distinct count of WorkOrderID as your summary at any group level

The distinct count can be used at the report level (all)

or also at each group level say if you grouped by @department.
Or add a crosstab to your report header and add the column in the rows by your @programs and the summary field as the distinct count of WOid.