Skip to Content
0
Former Member
Aug 09, 2016 at 12:02 PM

Suppress Group & Its Details Conditionally

26 Views

Hi All,

I'm building a report based on these values:

WO.DATETIME (Date/Time)

WO.WONUM (Work order number)

WO.SEQNUM ---Left Out Join --> SEVT.SEQNUM

SEVT.RESDESC (Contains description of a resource, e.g. Analyist A, Analyist B, Anlayst C, Transport....)

SEVT.COST (Contains cost of a booked resource)

SEVT.RTYPEIDCODE ----Left Outer Join ----> RESTYPE.TYPECODE

I'm grouping like this:

Group: Analyst A // Grouped using SEVT.RESDESC

-SubGroup: WO.WONUM (Header Suppressed, so that transport fee paid for Analyst A is shown below together under the same group)

Detail: - Analyst A Fees = $100 // I using SEVT.RESDESC & SEVT.COST in a formula

- Transport Fees = $100 // Same like above

Group Footer: Total = $200 // I'm using regular method to total up the group contents

I see the result like this:

Analysy A

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

Analyst A Fees = $100 WO # 11111
Transport Fees = $100 WO # 11111