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?
ThanksI'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.|||Got it. Works gr8! Thanks
Showing posts with label regionsectorintervalareacrew. Show all posts
Showing posts with label regionsectorintervalareacrew. Show all posts
Subscribe to:
Posts (Atom)