Do you have a field that identifies whether the item is active or terminated? If so, this is fairly simple.
1. Group on the active/terminated field - I'll call it {table.status} for this example.
2. Insert a second group header section for this group. In one, put the header that you want to show if {table.status} is Active, in the other put the data you want to show if it {table.status} is Terminated.
3. Create a second details section and set up so that you have one for Active and one for Terminated.
4. Right-click on sections area to the left of your screen and click on Section Expert. For each of the Active sections click on the button to the right of "Suppress" (do NOT check the check box!) and something like the following in the formula:
{table.status} <> 'Active'
Do the same thing for the Terminated sections.
This will suppress the sections that aren't supposed to print for each status.
-Dell
IP Logged
