I have a report procedure created in Developer Studio. I want to perform a primary sort, secondary sort and tertiary sort. The primary sort (i.e. first By field) on the workdate field works fine but, when I add a secondary sort (i.e. second By field) on the nurse type field and tertiary sort (i.e. third By field)
on the seniority date field I get duplication of data. How do I rectify this issue so that I can have 3 sort of by fields without data duplication?

This message has been edited. Last edited by: BKR,

What is the structure of the source ?

Are there joins involved ?

Is the master a multisegemtn master ?

Some more information woul dbe handy.

Take a glance at this link

Similar multiple sort fields were discussed in this post.

What is the structure of the source ? 1 SQL table

Are there joins involved ? No joins are involved

Is the master a multisegemtn master ? single segment master

Can you post the code ?

-SET &ECHO=ALL;
DEFINE FILE NUR_TIMECARDS
location/A10=IF LOCATION EQ ' ' THEN 'OTHER' ELSE LOCATION;
jobcode/A10=IF JOB_CODE EQ ' ' THEN DEFAULT_JOB_CODE ELSE JOB_CODE;
paidhours/P8.2=IF EARNING_MNEMONIC EQ 'D' OR 'OT1.5' OR 'SP' OR 'RSRCH' OR 'CLR' OR 'PLC' OR 'MDF' OR 'PLC/MGMT' OR 'INS' OR 'PEP' OR 'TRAINING' OR 'MM' OR 'CLP' OR 'CAP1.5' OR 'HLTH' OR 'ILL' OR 'ORIENT' OR 'OSW' OR 'PEP1.5' OR 'W/L' OR 'WMDF' OR 'SMDF-PT' OR 'ED-PIP' OR 'P4R' OR 'CAPITAL' OR 'OT-B P/O' OR 'OT1.5' OR 'OT2.5' OR 'CB1.5' OR 'CB2' OR 'CB2.5' OR 'OT2.0' OR 'CBONA1.5' OR 'RSRCH1.5' OR 'CPI 1.5' OR 'SP1.5' OR 'CBOPS1.5' OR 'NYW' OR 'HDW' OR 'GFW' OR 'VDW' OR 'JNW' OR 'CDW' OR 'CVW' OR 'LDW' OR 'TGW' OR 'RDW' OR 'XMW' OR 'BDW' OR 'EMW' OR 'WW' OR 'PL' OR 'JD' OR 'BRV' OR 'EDU' OR 'UL' OR 'SWCB' OR 'SMDF-PT' OR 'SC' OR 'S' OR 'V' OR 'VAC-P/O' OR 'STAT-P/O' OR 'NYT' OR 'F1T' OR 'HDT' OR 'GFT' OR 'VDT' OR 'F2T' OR 'JNT' OR 'CDT' OR 'CVT' OR 'LDT' OR 'TGT' OR 'RDT' OR 'XMT' OR 'BDT' OR 'ADT' OR 'EMT' OR 'SAL-CONT' OR 'MISC' OR 'MET' THEN TC_HOURS ELSE 0.00;
-* EMPDUP/A10=IF EARNING_MNEMONIC EQ EARNING_MNEMONIC THEN ' ' ELSE EARNING_MNEMONIC;
END
TABLE FILE NUR_TIMECARDS
PRINT
DISPLAY_NAME
EARNING_MNEMONIC
SCHEDULE_CODE
jobcode AS 'CHG JOB CODE'
TC_HOURS AS 'TOTALS'
paidhours AS 'PAID HOURS'
-* COMPUTE EMPDUP/A10 = IF EARNING_MNEMONIC EQ LAST EARNING_MNEMONIC THEN '' ELSE EARNING_MNEMONIC;
BY WORK_DATE
BY NURSE_TYPE
BY SENIORITY_DATE
ON TABLE SUBHEAD
"Detailed Timecard Hours by Cost Centre<+0> "
" "
"Cost Centre: <+0> &DEPARTMENT "
" "
"Date Range: &DATE_START - &DATE_END "
" "
ON TABLE SUBFOOT
" "
"Run date: WHERE WORK_DATE GE '&DATE_START.(FIND WORK_DATE IN NUR_TIMECARDS).Start Date.';
WHERE WORK_DATE LE '&DATE_END.(FIND WORK_DATE IN NUR_TIMECARDS).End Date.';
WHERE CHARGE_DEPT EQ &DEPARTMENT.(OR(FIND CHARGE_DEPT IN nur_timecards)).Department.;
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL' TC_HOURS paidhours
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
LINES-PER-PAGE=20,
$
TYPE=DATA,
COLUMN=N1,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=14,
BACKCOLOR='WHITE',
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=18,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=16,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=18,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=18,
BACKCOLOR=RGB(205 205 205),
$
TYPE=TABHEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
BACKCOLOR=RGB(155 155 155),
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=16,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=18,
$
TYPE=TABFOOTING,
SIZE=12,
BACKCOLOR='WHITE',
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
$
TYPE=TABFOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
BY=1,
SIZE=10,
STYLE=BOLD+ITALIC,
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
ENDSTYLE
END

7.6.8, Windows XP
Excel, PDF, Active HTML, HTML, PDF

I just attached the current code for my report procedure.

Change your PRINT to SUM and report back.

Thanks Prairie, There is no data duplication now but, the Total Hours and Paid Hours are incorrect now. Sometimes doubled, tripled, etc from what they should be.

Add a MAX. to the TC_HOURS and paidhours.

When you added the SUM, the request summed up the numeric values for each sort field combination. By adding a MAX, MIN, FST or LST, you should get a non aggregated amount.