Displaying records in subreport

[gems]

My report is grouped by the following fields.

Region
Sector
Interval
Area
Crew Unit

I have 8 different formulas that counts the records found under each and display them under each area by crew tech.

It looks something like this


Region: Central
Secotr: 11
Interval: Weekly or Greater (this is based on a formula)
Area: ESU

crew/tech Equip Not Available Parts On Order Timely Complete etc.
AAA 5 0 2

----------------
Next page
Region: Central
Secotr: 11
Interval: Weekly or Greater (this is based on a formula)
Area: COMM

crew/tech Equip Not Available Parts On Order Timely Complete etc.
BBB 0 0 3
CCC 5 0 1

------------


Now, I have a subreport where I want to display the records found under
each column in detail but for both areas combined. So for "Equip Not Available" it needs to display 5+5 records under Area-ESU and COMM. Then on the next page it will display 2+3+1 records for "Timely Complete" for Area-ESU and COMM. What I did was in the subreport I created another formula {@grpname} which had above formulas combined and grouped the subreport by that formula. That works fine.
But the problem is that - Out of the 8 formulas I want to display detail records for only 5 of them even if it finds records for the other 3 formulas.
This is how my {@grpname} formula looks like -


If {pPMPERDET.COMPLETION_STATUS} = "X" AND {pPMPERDET.END_DATE_TIME} < {pPMPERDET.LATEST_DATE} then
"Equip Not Available" else

If {pPMPERDET.COMPLETION_STATUS}) = "O" AND
{pPMPERDET.INTERVAL_LENGTH = ''} then
"Timely Complete"
//etc for all the 5 groups



Right now it displays the records for the 5 groups but in addition to that it is also displaying the remaining records found under no heading. How should I stop it from displaying these records?

Thanks

[kristyw]

I'm not entirely sure what it is you're describing below, but it sounds like you want to look at suppressing either fields or entire subreports/sections.

To suppress a subreport : put it in it's own section, right click the section and go to Section Expert -> next to the Suppress option there is an x+2 button.

To suppress a field : right click it, go to Format Field (Common tab) and next to Suppress option is the x+2 box.


Suppression formula must return true or false. Use formula editor to get the result you're after, for example...

If IsNull( [your group name] ) then
true --yes, suppress the subreport/field
else
false --no, don't suppress.

[gems]

Got it. Works gr8! Thanks