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