Hi All,

Please are you able to help.

I am trying to produce a report that shows a person's clocking events for a week.The report shows clock 'in' and 'out' event across each date for that week. then daily & weekly total is calculated.


e.g.
16/11/2010 17/11/2010 weekly
SAP_ID NAME IN OUT Tot IN OUT Tot Tot
80000 Mike 7:00 12:00 5.00 18.00 7:00 13:00
Philips


In the example, there is a night shift happened on 17/11/2010. The person clocked in at 18:00 on 17th and clocked out ot 7:00 am on 18/11/2010.


In the report,the out time is appearing in 17/11/2010 's Out column that ideally should appear in 18/11/2010's out column.

The requirement is to either show the out time in correct date's column, or the same out time that is being shown on 17th should be copied to the Out time field for 18/11/2010 column.

We are not able to achieve that as we have placed the In & out time in the report painter to show the times across the dates.

Please could anyone of you let me know how to achieve this requirement.

Can it be handled via the webfocus program or any database change needs to be done.

Any quick help will be highly appreciated.

Thanks,
Mou

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

Can you please publish your MFD so we can see how the data is stored.

Hi OPALTOSH,

Many thanks for your reply.

Please find the structure as follows. This is the MFD from which the report has been created.

FILENAME=TEST_NIGHT_TAB, SUFFIX=FOC , $
SEGMENT=SEG01, SEGTYPE=S12, $
FIELDNAME=SITE_NAME, ALIAS=E01, USAGE=A15, $
FIELDNAME=WEEK_NO, ALIAS=E02, USAGE=A2,
MISSING=ON, $
FIELDNAME=CONTRACTOR_COMPANY, ALIAS=E03, USAGE=A100,
MISSING=ON, $
FIELDNAME=SAP_ID, ALIAS=E04, USAGE=A128,
MISSING=ON, $
FIELDNAME=CONTRACTOR_NAME, ALIAS=E05, USAGE=A100,
MISSING=ON, $
FIELDNAME=TRADE, ALIAS=E06, USAGE=A40,
MISSING=ON, $
FIELDNAME=CLK_STN_FINAL, ALIAS=E07, USAGE=A265, $
FIELDNAME=CLK_STN_FINAL1, ALIAS=E08, USAGE=A265, $
FIELDNAME=DATE_NUM, ALIAS=E09, USAGE=DMYY, $
FIELDNAME=DAY_NO, ALIAS=E10, USAGE=A2,
MISSING=ON, $
FIELDNAME=DAYNAME1, ALIAS=E11, USAGE=A10,
MISSING=ON, $
FIELDNAME=FOCLIST , ALIAS=E12, USAGE=I9, $
FIELDNAME=START_TIME, ALIAS=E13, USAGE=A5,
MISSING=ON, $
FIELDNAME=END1, ALIAS=E14, USAGE=A5,
MISSING=ON, $
FIELDNAME=CLKED_HRS, ALIAS=E15, USAGE=D20.2,
MISSING=ON, $

The oracle view from which the above MFD has been created is as follows.
FILENAME=TEST_NIGHT, SUFFIX=SQLORA , $
SEGMENT=TEST_NIGHT, SEGTYPE=S0, $
FIELDNAME=CONTRACTOR_COMPANY, ALIAS=CONTRACTOR_COMPANY, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=CONTRACTOR_NAME, ALIAS=CONTRACTOR_NAME, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=SAP_ID, ALIAS=SAP_ID, USAGE=A128, ACTUAL=A128,
MISSING=ON, $
FIELDNAME=SITE, ALIAS=SITE, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=DAY_NO, ALIAS=DAY_NO, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=STN_IN, ALIAS=STN_IN, USAGE=A255, ACTUAL=A255,
MISSING=ON, $
FIELDNAME=STN_OUT, ALIAS=STN_OUT, USAGE=A255, ACTUAL=A255,
MISSING=ON, $
FIELDNAME=WK_END_DT, ALIAS=WK_END_DT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON, $
FIELDNAME=TRANSDATE, ALIAS=TRANSDATE, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON, $
FIELDNAME=TRANSDATE2, ALIAS=TRANSDATE2, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON, $
FIELDNAME=WEEK_NO, ALIAS=WEEK_NO, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=TRADE, ALIAS=TRADE, USAGE=A40, ACTUAL=A40,
MISSING=ON, $
FIELDNAME=DATE_NO, ALIAS=DATE_NO, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON, $
FIELDNAME=START_TIME, ALIAS=START_TIME, USAGE=A5, ACTUAL=A5,
MISSING=ON, $
FIELDNAME=END1, ALIAS=END1, USAGE=A5, ACTUAL=A5,
MISSING=ON, $
FIELDNAME=CLKED_HRS, ALIAS=CLKED_HRS, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $


The report fex is as follows-* File grp4_view_test_bkp.fex

-SET &ECHO = ALL;

-SET &CURRDATE = EDIT(&YYMD, '9999') || EDIT(&YYMD, '$$$$99')|| EDIT(&YYMD, '$$$$$$99');
-SET &PREV_START_DATE = &CURRDATE - 7 ;


DEFINE FILE TEST_NIGHT

DAYNAME1 /A10 MISSING ON = IF DAY_NO EQ '1' THEN 'Sunday' ELSE
IF DAY_NO EQ '2' THEN 'Monday' ELSE
IF DAY_NO EQ '3' THEN 'Tuesday' ELSE
IF DAY_NO EQ '4' THEN 'Wednesday' ELSE
IF DAY_NO EQ '5' THEN 'Thursday' ELSE
IF DAY_NO EQ '6' THEN 'Friday' ELSE
IF DAY_NO EQ '7' THEN 'Saturday' ELSE 'X';

C_LEN/I3 = ARGLEN(255, STN_IN, 'I3');
C_FMT/A4 = 'A'||EDIT(C_LEN);
CLK_NAME1/A3 = REVERSE(3,REVERSE(C_LEN,STN_IN,C_FMT),'A3');
CLK_NAME2 /A255 = IF CLK_NAME1 EQ 'IN ' THEN SUBSTR(C_LEN, STN_IN, 1, C_LEN - 2, 255, CLK_NAME2)
ELSE SUBSTR(C_LEN, STN_IN, 1, C_LEN-3, 255, CLK_NAME2);
CLK_STN_FINAL/A265 = EDIT(CLK_NAME2,'9999$');

C_LEN1/I3 = ARGLEN(255, STN_OUT, 'I3');
C_FMT1/A4 = 'A'||EDIT(C_LEN1);
CLK_NAME3/A3 = REVERSE(3,REVERSE(C_LEN1,STN_OUT,C_FMT1),'A3');
CLK_NAME4 /A255 = IF CLK_NAME3 EQ 'IN ' THEN SUBSTR(C_LEN1, STN_OUT, 1, C_LEN1 - 2, 255, CLK_NAME4)
ELSE SUBSTR(C_LEN1, STN_OUT, 1, C_LEN1-3, 255, CLK_NAME4);
CLK_STN_FINAL1/A265 = EDIT(CLK_NAME4,'9999$');

SITE_NAME/A15 = IF SITE EQ 'P' THEN 'Port Talbot' ELSE IF SITE EQ 'L' THEN 'Llanwern' ELSE SITE_NAME;
DATE_NUM /DMYY = DATE_NO;

IN_TRANSDATE/YYMD = TRANSDATE;
OUT_TRANSDATE/YYMD = TRANSDATE2;
END



TABLE FILE TEST_NIGHT
PRINT
'TEST_NIGHT.TEST_NIGHT.START_TIME'
'TEST_NIGHT.TEST_NIGHT.END1'
'TEST_NIGHT.TEST_NIGHT.CLKED_HRS'
BY 'TEST_NIGHT.TEST_NIGHT.SITE_NAME'
BY 'TEST_NIGHT.TEST_NIGHT.WEEK_NO'
BY 'TEST_NIGHT.TEST_NIGHT.CONTRACTOR_COMPANY'
BY 'TEST_NIGHT.TEST_NIGHT.SAP_ID'
BY 'TEST_NIGHT.TEST_NIGHT.CONTRACTOR_NAME'
BY 'TEST_NIGHT.TEST_NIGHT.TRADE'
BY 'TEST_NIGHT.TEST_NIGHT.CLK_STN_FINAL'
BY 'TEST_NIGHT.TEST_NIGHT.CLK_STN_FINAL1'
BY 'TEST_NIGHT.TEST_NIGHT.DATE_NUM'
BY 'TEST_NIGHT.TEST_NIGHT.DAY_NO'
BY 'TEST_NIGHT.TEST_NIGHT.DAYNAME1'
WHERE IN_TRANSDATE GE '20101107'
WHERE OUT_TRANSDATE LE '20101114'
-*WHERE SAP_ID EQ '80020924'
ON TABLE NOTOTAL
ON TABLE HOLD AS TEST_NIGHT_TAB FORMAT FOCUS
END


TABLE FILE TEST_NIGHT_TAB
PRINT
'TEST_NIGHT_TAB.SEG01.START_TIME' AS 'In'
'TEST_NIGHT_TAB.SEG01.END1' AS 'Out'
'TEST_NIGHT_TAB.SEG01.CLKED_HRS' AS 'Tot'
BY 'TEST_NIGHT_TAB.SEG01.CONTRACTOR_COMPANY' NOPRINT AS 'Contracting_Company'
BY 'TEST_NIGHT_TAB.SEG01.SITE_NAME' NOPRINT AS 'Site'
BY 'TEST_NIGHT_TAB.SEG01.WEEK_NO' NOPRINT AS 'Week No'
BY 'TEST_NIGHT_TAB.SEG01.SAP_ID' AS 'SAP_No'
BY 'TEST_NIGHT_TAB.SEG01.CONTRACTOR_NAME' AS 'Name'
BY 'TEST_NIGHT_TAB.SEG01.TRADE' AS 'Trade'
BY 'TEST_NIGHT_TAB.SEG01.CLK_STN_FINAL' AS 'Clk In'
BY 'TEST_NIGHT_TAB.SEG01.CLK_STN_FINAL1' AS 'Clk Out'
ACROSS 'TEST_NIGHT_TAB.SEG01.DATE_NUM' AS ''
ACROSS 'TEST_NIGHT_TAB.SEG01.DAY_NO' NOPRINT
ACROSS 'TEST_NIGHT_TAB.SEG01.DAYNAME1' AS ''
COMPUTE
TOT/D12.2 = C3 + C6 + C9 + C12 + C15 + C18 + C21; AS 'Total'
ON TEST_NIGHT_TAB.SEG01.CONTRACTOR_COMPANY SUBTOTAL AS 'TOTAL For'
ON TEST_NIGHT_TAB.SEG01.CONTRACTOR_COMPANY PAGE-BREAK
ON TABLE SUBHEAD
"Tata Steel Strip Products UK"
"Daily Audit Print of Contractor Clocking"
HEADING
"Contracting Company<+0>:"Site: "Week No.:ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=10,
RIGHTGAP=0.125000,
$
TYPE=DATA,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N1,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N2,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=SOLID,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-TOP-COLOR='BLACK',
BORDER-BOTTOM-COLOR='BLACK',
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=SOLID,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N3,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N11,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
BACKCOLOR=RGB(174 255 174),
$
TYPE=DATA,
COLUMN=N12,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
BACKCOLOR=RGB(174 255 174),
$
TYPE=DATA, FONT='ARIAL', SIZE=9, $
TYPE=DATA, COLUMN=TOT, STYLE=NORMAL, BACKCOLOR=RGB(192 192 192),
$
TYPE=DATA,
ACROSSCOLUMN=N4,
FONT='ARIAL',
SIZE=10,
STYLE=NORMAL,
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N1,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N2,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=SOLID,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
BORDER-TOP-COLOR='BLACK',
BORDER-BOTTOM-COLOR='BLACK',
BORDER-LEFT-COLOR='BLACK',
BORDER-RIGHT-COLOR='BLACK',
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=SOLID,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=SOLID,
BORDER-BOTTOM-STYLE=SOLID,
BORDER-LEFT-STYLE=SOLID,
BORDER-RIGHT-STYLE=SOLID,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(228 201 44),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(4),
STYLE=BOLD,
$
TYPE=TITLE,
ACROSSCOLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
ACROSSCOLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
ACROSSCOLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
ACROSSCOLUMN=N4,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(230 203 53),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=16,
COLOR=RGB(51 102 255),
STYLE=BOLD,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=16,
COLOR=RGB(51 102 255),
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABFOOTING,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR=RGB(205 205 205),
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
BACKCOLOR=RGB(205 205 205),
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=12,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=.431,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=16,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=.167,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=16,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=2.264,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=.681,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=.167,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=2.153,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=.681,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=.167,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
STYLE=BOLD,
JUSTIFY=LEFT,
WIDTH=2.153,
$
TYPE=SUBHEAD,
BY=1,
SIZE=9,
BACKCOLOR=RGB(255 187 221),
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=2,
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=2,
SIZE=9,
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=2,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=SUBHEAD,
BY=3,
LINE=1,
OBJECT=TEXT,
ITEM=1,
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=3,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BY=1,
BACKCOLOR=RGB(204 255 255),
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
ACROSS=2,
FONT='ARIAL',
SIZE=9,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=ACROSSVALUE,
ACROSS=3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
ACROSS=4,
FONT='ARIAL',
SIZE=9,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
ACROSS=5,
FONT='ARIAL',
SIZE=9,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(1),
JUSTIFY=CENTER,
$
TYPE=ACROSSTITLE,
ACROSS=1,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(23 255 139),
STYLE=BOLD,
$
TYPE=ACROSSTITLE,
ACROSS=2,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(23 255 139),
STYLE=BOLD,
$
TYPE=ACROSSTITLE,
ACROSS=3,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(23 255 139),
STYLE=BOLD,
$
TYPE=ACROSSTITLE,
ACROSS=4,
FONT='ARIAL',
SIZE=10,
BACKCOLOR=RGB(23 255 139),
STYLE=BOLD,
$
TYPE=ACROSSTITLE,
ACROSS=5,
FONT='ARIAL',
BACKCOLOR=RGB(23 255 139),
STYLE=BOLD,
$
TYPE=REPORT,$
COLUMN=TOT,STYLE= BOLD,
FONT='ARIAL',SIZE=10,
$
TYPE=GRANDTOTAL,
FONT='ARIAL',
BACKCOLOR=RGB(204 255 255),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=0.652778,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.430556,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.291667,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=1.180556,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=1.430556,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=0.805556,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=0.652778,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N11,
FONT='ARIAL',
SIZE=10,
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=0.652778,
$
ENDSTYLE
END

Webfocus Release -Webfocus 7.6.5
OS/Platform - Windows XP
Expected Output formats - HTML,EXCEL,PDF etc

I can see lots here that I'd change but it is very complicated without data to work with.

If yo are happy to send me a subset of data (you can leave out the names) that has the night shift scenario and and complete copy of your FEX I'd be happy to have a go at producing the result you want. It can be a flat file, a CSV file, an ACCESS mdb or a FOC file. Makes no difference.

My direct email is gpotter@opalibusiness.com.au.

I love a reporting challenge!

My first observation is that there are not separate dates associated with the start and end times of each shift so it not surprising that you get the result you see.

Hi OPALTOSH,

Thanks for your reply.

I also understand that the having no separate dates is causing this problem. I am in the process of getting a quick confirmation from the business regarding sending a subset of data .If approved, will send you the same to your mail id.

Thanks once again.

Thanks,
Mou