I have a report that Groups by Rep Name and Sorts by State. I have it set so the Group shows only when Rep Name is Active. My problem is that the Rep name doesn't show up(like I want) but the States are still there. How do I get the states to only appear if the Group (Rep) is included? The first screen shot show the design view of the report and the grouping. The second is a view from the report view. There would normally be a Rep name under each subtotal.
Thanks.