I do I create a report with only a few column summed and the others as print,in the fex below the by statement for comment_text the users want to seen even if it is the same for each transactions.

-* File gl_detail.fex
-* 02/03/09 resorted took off most of the sums
DEFINE FILE WF_GL_DETAIL_VIEW ADD
Debits/D15.2=IF WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSAMNT GE 0 THEN WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSAMNT ELSE 0;
Credits/D15.2=IF WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSAMNT LT 0 THEN WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSAMNT ELSE 0;
END
TABLE FILE WF_GL_DETAIL_VIEW
SUM
'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSQTY' AS 'Qty'
'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.Debits' AS 'Debit'
'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.Credits' AS 'Credit'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER' NOPRINT AS 'Ctr'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO' AS 'Account,Number'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNAME' AS 'Description'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSTYPE' AS 'TT'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSDATE' AS 'Transdate'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.REFERENCENO' AS 'Reference,Number'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.COMMENT_TEXT' AS 'Comment'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PERIOD' NOPRINT AS 'Per,'

ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER SUBTOTAL AS '*Total For Center'

ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO SUBTOTAL AS '*Total For Account'

ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.TRANSTYPE SUBTOTAL AS '*Total For TT'
HEADING
"&DATEtMDYY <+0> &TOD"
"P C C S T R U C T U R A L S, I N C."
"Cost Center Ranges : Detail Financial Report"
"By Cost Center, Acct Number, Trans Type and Transaction Date"
"For Period &PERIOD.Period:. Fiscal Year &FISCALYEAR.Fiscal Year:."
" "
WHERE ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PERIOD EQ &PERIOD ) AND ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.FISCAL_YEAR EQ &FISCALYEAR ) AND ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PLANT GE '&PLANT1.Plant GE: Plant Is 2 Digits.' ) AND ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PLANT LE '&PLANT2.Plant LE: Plant Is 2 Digits.' );
ON TABLE SET PAGE-NUM ON
ON TABLE SUMMARIZE AS '** Grand Total'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='COURIER',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=5,
JUSTIFY=CENTER,
$
TYPE=PAGENUM,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=0.680556,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=0.916667,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=1.236111,
$
TYPE=REPORT,
COLUMN=N11,
SQUEEZE=1.402778,
$
TYPE=REPORT,
COLUMN=N14,
SQUEEZE=1.180556,
$
TYPE=REPORT,
COLUMN=N13,
SQUEEZE=1.388889,
$
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=1.000000,
$
TYPE=REPORT,
COLUMN=N10,
SQUEEZE=1.305556,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=0.625000,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=0.305556,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=1.222222,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=1.972222,
$
ENDSTYLE
END

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

reverse the order of the last two BYs.

I'm still dropping records, I've tried adding another column timestamp and still no luck,

Is there any way of just displaying this field as print when I have other fields as sum

The way you've phrased the question, the answer is "no" -- with a single verb you cannot "print" some columns and "sum" others. The choice of verb determines the number of rows produced --
* If the verb is PRINT, there will be one output row per input row that passes the screening conditions.
* If the verb is SUM, the incoming data that pass the conditions will be "summarized" to propduce exactly one row per unique combination of sort (BY) values.

-- but regardless of the verb, every output row contains a value for every column (although the value of sort variables is only displayed at sort breaks and page breaks).

But (as was hinted earlier) if you use multiple verbs, along the lines of:

SUM the 3 measures (qty, Debit, and Credit)
BY a bunch of sort columns
PRINT comment_text
BY the same bunch of sort columns

then each sort break will show values for the measures on one line, and comment_text on one or more lines (as many instances as there are incoming data rows, one for one).

But note: That rule about 1-for-1 relation between input and output rows holds true even where the incoming record's comment_text is blank. If you want to display every non-blank comment, but still show the measures when there are no non-blank comments, it will take more work.

tHANKS, THAT WORKED