Crystal Version 9
Data AS400
Data is coming from 4 tables
FM300
FM310
FM305
FM315
All of these tables are linked with Primary key Work Order Number.
I have to generate a report for Road Calls with AC failure for month XX.
Formula's used
FM310.FMPSC is between 1300 -1318
FM300.FMWCC = 1 (Road Call)
FM300.FMCDTE = month
Fields displayed is coming from follwing tables
FM305 has Operator Comp ( Header Section)
FM310 has Sustem Codes (Detail Section)
FM315 has Description (Detail Section)next to system code
Report is grouped with Workorder no .
Workorder No , Bus No & Operator Complaint are in the group header section.
Work done (System codes) are in the detail section. As for one WO there could be max of 30 system codes or 30 lines identified by system code .
Problem :- Below is the output
WONo: 5460093 Bus PB9715 Operator's Com No Charge Light ON
6/1/2005 1300 Road Call for No AC
6/1/2005 1300 Replaced AC belt & drove Bus back to Shop
WO No:547629 Bus PB0009 Operator's Com:NO AC
6/9/2005 1301 Swap Out
6/9/2005 1301 Checked Ac Code
Total records are 47. Total groups are 13
Groups are fine however number of recors are duplicate.
like in first Group the first recors is some differnt system code 8010 however it is showing in the report with 1300.
In these workorders there could be more system codes however I want to pick only 1300-1318.
I tried suppress duplicate records in Common Option & select distinct records.
I hope this makes sense................
Any suggestions .................. Iam just a beginner in Crystal reports .
Data AS400
Data is coming from 4 tables
FM300
FM310
FM305
FM315
All of these tables are linked with Primary key Work Order Number.
I have to generate a report for Road Calls with AC failure for month XX.
Formula's used
FM310.FMPSC is between 1300 -1318
FM300.FMWCC = 1 (Road Call)
FM300.FMCDTE = month
Fields displayed is coming from follwing tables
FM305 has Operator Comp ( Header Section)
FM310 has Sustem Codes (Detail Section)
FM315 has Description (Detail Section)next to system code
Report is grouped with Workorder no .
Workorder No , Bus No & Operator Complaint are in the group header section.
Work done (System codes) are in the detail section. As for one WO there could be max of 30 system codes or 30 lines identified by system code .
Problem :- Below is the output
WONo: 5460093 Bus PB9715 Operator's Com No Charge Light ON
6/1/2005 1300 Road Call for No AC
6/1/2005 1300 Replaced AC belt & drove Bus back to Shop
WO No:547629 Bus PB0009 Operator's Com:NO AC
6/9/2005 1301 Swap Out
6/9/2005 1301 Checked Ac Code
Total records are 47. Total groups are 13
Groups are fine however number of recors are duplicate.
like in first Group the first recors is some differnt system code 8010 however it is showing in the report with 1300.
In these workorders there could be more system codes however I want to pick only 1300-1318.
I tried suppress duplicate records in Common Option & select distinct records.
I hope this makes sense................
Any suggestions .................. Iam just a beginner in Crystal reports .