Suppress Previous Cr Report 8.5

[gtjr92]

I am trying to supress a section if the previous result was the same. We have main workorders that have sub workorders to them all of the sub workorders relate back to one main workorder. I want the main workorder to only show up once in the report and all the sub orders after. I have it working except that It keeps showing multiple listings for the main workorder. I have tried to add the below lines to the formula section to supress.
If i do this
[highlight]{WORKORDER.WONUMB} And {WORKORDER.WOSEQN} =Previous {WORKORDER.WONUMB} And Previous{WORKORDER.WOSEQN}[/highlight] I get the remaining text does not appear to be part of the formula. The cursor goes to right after the first previous indication the error may be there?
If I try [highlight]
(({WORKORDER.WONUMB} And {WORKORDER.WOSEQN})) =Previous (({WORKORDER.WONUMB}) And Previous({WORKORDER.WOSEQN}))[/highlight]
I get boolean is required here the cursor shows up right before the first tablename.
I know it must just be some simple thing i am missing.
Thanks for any help!

 

[lbass]

{WORKORDER.WONUMB} = Previous ({WORKORDER.WONUMB}) And
{WORKORDER.WOSEQN}= Previous({WORKORDER.WOSEQN})

This will suppress the row if both fields are the same as in the previous record.

-LB

 

[GJParker]

Why not simply create a group on main workorder and place info in the group header section.

HTH


Gary Parker
MIS Data Analyst
Manchester, England

 

[gtjr92]

lbass suggestion worked like a charm. I guess I was just outthinking myself!
Thanks!