Hi Guys,

I am trying to create 2 reports in 1 FEX with the usage of Compound Reports, but I faced this error upon execution, report could be run the 1st report is able to show, the 2nd report is nowhere to be seen

quote:

(FOC2526) WARNING: NO JOIN CONDITION SPECIFIED FOR SEGMENT : CUST
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
0 HOLDING HTML FILE ON PC DISK ...
(FOC3298) ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....

Following is my code :

-INCLUDE gen_def_env_vars
-SET &IMGURL = IF &WFFMT EQ 'PDF' THEN &PDFIMGURL ELSE &HTMLIMGURL

SET EMPTYREPORT = ON
JOIN
 INNER FILE APPL AT APPL.APPL.ANKIPN TO MULTIPLE FILE CUST AT CUST.CUST.IPKIPN
 TAG J0 AS J0
 WHERE ANAVST EQ '009' OR ANAVST EQ '002' ;
 END
  JOIN
 LEFT_OUTER FILE APPL AT APPL.APPL.ANOTYP TO UNIQUE FILE GEN_CODE
 AT GEN_CODE.GEN_CODE.GCGCOD TAG J1 AS J1
 WHERE J1.GEN_CODE.GCCTYP EQ 'APO' AND APPL.APPL.ANOTYP EQ J1.GEN_CODE.GCGCOD;
 END

DEFINE FILE APPL
DATE1/A10 = '&dateFrom';
DD1/A2 = EDIT(DATE1,'99$$$$$$$$');
MM1/A2 = EDIT(DATE1,'$$$99$$$$$');
YY1/A4 = EDIT(DATE1,'$$$$$$9999');
DATE2/A10 = '&dateTo';
DD2/A2 = EDIT(DATE2,'99$$$$$$$$');
MM2/A2 = EDIT(DATE2,'$$$99$$$$$');
YY2/A4 = EDIT(DATE2,'$$$$$$9999');
DATEFROM/YYMD = DATECVT(EDIT(DD1|MM1|YY1),'I8DMYY','I8YYMD');
DATETO/YYMD = DATECVT(EDIT(DD2|MM2|YY2),'I8DMYY','I8YYMD');
STDTCENTURY/I7 = IF ARGLEN(7,EDIT(ANSTDT),STDTCENTURY) = 6 THEN 0 ELSE IF SUBSTR(7, EDIT(ANSTDT), 0, 1, 1, 'A1') = '1' THEN 1 ELSE 0;
STDT8/I8 = IF STDTCENTURY = 0 THEN 19000000 + ANSTDT ELSE IF STDTCENTURY = 1 THEN 20000000 + ANSTDT;
STDT/YYMD = DATECVT(STDT8, 'I8YYMD', 'I8YYMD');

Gold/I7=IF APPL.APPL.ANRKID EQ 'MBRGLD' THEN 1 ELSE 0;
Classic/I7=IF APPL.APPL.ANRKID EQ 'MBRSTD' THEN 1 ELSE 0;
END

SET COMPOUND=OPEN NOBREAK
TABLE FILE APPL
SUM
     'J1.GEN_CODE.GCDESC' AS 'Description'
     'APPL.APPL.Gold'
     'APPL.APPL.Classic'
BY 'APPL.APPL.ANOTYP' AS 'Code'
ON TABLE SUBHEAD
" "
" "
HEADING
"APPLICATION APPROVED FROM <+0>&dateFrom <+0>TO<+0> <+0>&dateTo"
" "
"PRODUCT VS ORIGIN"
FOOTING
" "
" "
WHERE ANAVST EQ '009' AND ANKIPN EQ IPKIPN;
WHERE CUST.CUST.IPFDAT NE 0;
WHERE STDT GE DATEFROM;
WHERE STDT LE DATETO;
ON TABLE SET PAGE-NUM ON
ON TABLE ROW-TOTAL/I11 AS 'Total'
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
  GRID=OFF,
     ORIENTATION=PORTRAIT,
     PAGECOLOR=RGB(245 245 245),
$
TYPE=REPORT,
     FONT='COURIER NEW',
     SIZE=9,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=( 'WHITE' RGB(242 238 240) ),
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(153 204 255),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     IMAGE=&IMGURL,
     POSITION=(+0.055556 -0.027778),
     SIZE=(1.680556 0.402778),
$
TYPE=TABFOOTING,
     SIZE=12,
$
TYPE=HEADING,
     SIZE=12,
$
TYPE=HEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=3,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD+UNDERLINE,
$
TYPE=FOOTING,
     SIZE=8,
$
TYPE=SUBHEAD,
     SIZE=10,
$
TYPE=SUBFOOT,
     SIZE=10,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
     BACKCOLOR=RGB(255 255 153),
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=PAGENUM,
     JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
ENDSTYLE
END

SET COMPOUND=CLOSE
TABLE FILE APPL
SUM
     'J1.GEN_CODE.GCDESC' AS 'Description'
     'APPL.APPL.Gold'
     'APPL.APPL.Classic'
BY 'APPL.APPL.ANOTYP' AS 'Code'
HEADING
"APPLICATION REJECTED FROM <+0>&dateFrom <+0>TO<+0> <+0>&dateTo"
" "
"PRODUCT VS ORIGIN"
FOOTING
" "
" "
" "
"Private & Confidential"
"Report Generated On <+0>&DATEtrDMYY<+0> <+0>   "
WHERE ANAVST EQ '002' AND ANKIPN EQ IPKIPN;
WHERE CUST.CUST.IPFDAT NE 0;
WHERE STDT GE DATEFROM;
WHERE STDT LE DATETO;
ON TABLE SET PAGE-NUM OFF
ON TABLE ROW-TOTAL/I11 AS 'Total'
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET STYLE *
     UNITS=IN,
  GRID=OFF,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     PAGECOLOR=RGB(245 245 245),
$
TYPE=REPORT,
     FONT='COURIER NEW',
     SIZE=9,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=( 'WHITE' RGB(242 238 240) ),
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(153 204 255),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
$
TYPE=HEADING,
     SIZE=12,
$
TYPE=HEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=3,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD+UNDERLINE,
$
TYPE=FOOTING,
     SIZE=12,
$
TYPE=FOOTING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=8,
$
TYPE=FOOTING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=7,
$
TYPE=FOOTING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=2,
     SIZE=7,
$
TYPE=FOOTING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=3,
     SIZE=7,
$
TYPE=FOOTING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=4,
     SIZE=7,
$
TYPE=SUBHEAD,
     SIZE=10,
$
TYPE=SUBFOOT,
     SIZE=10,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
     BACKCOLOR=RGB(255 255 153),
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
ENDSTYLE
END

quote:

StyleSheet formatting seems to be ugly when it is in compound report, is there anyway to retain stylesheet formatting?

Hope you guys can help me to take a look.

Thanks in advance.

This message has been edited. Last edited by: Kevin Tong,

I had alook in Techsupport and found one Troubleshooting entry.

This particular one talks about multisegment masters.

What is your data source, and do you have multiple segments in one of th masters.?

Here is a link to the Symptom/Problem/Solution.
http://techsupport.information...om/sps/51892013.html

If this does not help, the I would suggest putting in a case with IBI.

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

Thanks Waz for your reply.

Another question is how do we retain stylesheet formatting for compound reports when output in HTML format? The formatting runs and turned out ugly.

Is there any way to retain it?

Thanks.

I would strongly suggest using a cascading style sheet.

You can point to a CSS file with the SET CSSURL command.
Then set the class in the WF stylesheet with the option ... class={class name},....

This way the components that should be the same between reports will be the same.

Thanks Waz...

You appear to be missing the JOIN condition WHERE clause in your first JOIN.

JOIN
 INNER FILE APPL AT APPL.APPL.ANKIPN TO MULTIPLE FILE CUST AT CUST.CUST.IPKIPN
 TAG J0 AS J0
 WHERE APPL.APPL.ANKIPN EQ CUST.CUST.IPKIPN ;    <---------- Try adding this.
 WHERE ANAVST EQ '009' OR ANAVST EQ '002' ;
END

Thanks guys for your help.