I am trying to create a report where I can add
the Debit and Debit Card transactions from SYSP
to the Debit and Debit Card transactions from SYSS.

I cannot find any documentation using the 'MORE'
technique to do something like this.

Ideas anyone?

Here is the desired report output:

PAGE 1

Original Debit/Sales Report

JUL-07 AUG-07
VOLUMES SYSP

ON-LINE DEBIT Debit 135 141
Debit Card 243 202

SYSP 378 343

VOLUMES SYSS

ON-LINE DEBIT Debit 197 203
Debit CardDebit 306 302

SYSS 503 505

VOLUMES SYSP & SYSS

ON-LINE DEBIT Debit 332 344
Debit CardDebit 549 504


-*******************************************************************************
Here is the code...

TABLE FILE PERIOD
SUM
ACTL_NET_SALE_AM
-*
BY PLTF_ID
BY SYS_ID
BY DEBIT_FLG
BY PRDT_DSCR_TX
-*
ACROSS DATE_FULL_DT AS ''
ON PLTF_ID SKIP-LINE
-*
WHERE ((PLTF_ID EQ 'SO') OR (PLTF_ID EQ 'NO'));
-*WHERE PLTF_ID EQ '&PLTFM';
WHERE (DATE_FULL_DT GE '&BEG_DT');
WHERE (DATE_FULL_DT LE '&END_DT');
-*
-* SELECT FOR DEBIT
WHERE (PRDT_CD EQ '007' OR '012' OR '024' OR '025' OR '026' OR '046' OR '048');
-* SELECT FOR MasterCard AND Visa
WHERE (((PRDT_CD EQ '007' OR '012' OR '024' OR '025' OR '026' OR '046' OR '048')) OR
((PRDT_CD EQ '001')
AND (PLAN_CD EQ '075' OR '005' OR '006'))
OR ((PRDT_CD EQ '002')
AND (PLAN_CD NE '075' OR '007' OR '008')));
-* WHERE RECORDLIMIT EQ 2000
ON TABLE HOLD AS ONE
END
-RUN
-*
TABLE FILE ONE
HEADING CENTER
"Original Debit/Sales Report"
" "
"<+63 JUL-07 <+10 AUG-07 <+12 SEP-07"
PRINT
E05 AS '' IN 55
E06 AS '' IN 72
E07 AS '' IN 89
COLUMN-TOTAL
BY PLTF_ID NOPRINT
BY SYS_ID NOPRINT
BY DEBIT_FLG AS '' IN 17
BY PRDT_DSCR_TX AS '' IN 32
ON SYS_ID SUBTOTAL AS ''
ON SYS_ID SKIP-LINE
-*
ON SYS_ID SUBHEAD
"VOLUMES -*
ON TABLE PCHOLD FORMAT &FMT
END
-RUN

Thanks!

How about:

 
TABLE FILE PERIOD
SUM
ACTL_NET_SALE_AM
-*
BY PLTF_ID
BY SYS_ID 
BY DEBIT_FLG 
BY PRDT_DSCR_TX 
-*
ACROSS DATE_FULL_DT AS ''
ON PLTF_ID SKIP-LINE
-*
WHERE ((PLTF_ID EQ 'SO') OR (PLTF_ID EQ 'NO'));
WHERE (DATE_FULL_DT GE '&BEG_DT');
WHERE (DATE_FULL_DT LE '&END_DT');
-*
-* SELECT FOR DEBIT
WHERE (PRDT_CD EQ '007' OR '012' OR '024' OR '025' OR '026' OR '046' OR '048');

ON TABLE HOLD AS ONE
MORE
FILE PERIOD
-* SELECT FOR MasterCard AND Visa
WHERE (((PRDT_CD EQ '007' OR '012' OR '024' OR '025' OR '026' OR '046' OR '048')) OR
((PRDT_CD EQ '001')
AND (PLAN_CD EQ '075' OR '005' OR '006'))
OR ((PRDT_CD EQ '002')
AND (PLAN_CD NE '075' OR '007' OR '008'))); 

END
-RUN
-* ETC
 

Amazingly, the "MORE" command is documented in the "Creating Reports With WebFOCUS Language" document under "Universal Concatenation".

Can't I get this publication on tbe IB web site?

Thanks Francis

quote:

WebFOCUS Language" document under "Universal Concatenation

I just located a reference to it at:
.

I just located a reference to it at:

What Tomsweb meant to tell us is that he found documentation on Universal Concatenation.