I would like to position the total line and where the totals appear on the report.
Example:
-------------------------------------------------
ID TERM Name Group Status MoreCols...
123 2012 Joe Science Applied ...
234 2012 Fred Science Accepted ...
Total Science 2 Applied: 2
Accepted: 1
Denied: 0
567 2012 Chris Arts Accepted ...
678 2012 Linda Arts Denied ...
Total Science 2 Applied: 2
Accepted: 1
Denied: 1
Total 4 Applied: 4
Accepted: 2
Denied: 1
---------------------------------------------------
What is happening for the total section, it wraps and is on a separate line from the numerical totals.
Total
Science
2 1 0
I tried changing the section below with No wrap as well changing col numbers and wrap numbers, but neither seemed to work and caused error messages
TYPE=REPORT, COLUMN=N11, WRAP=6.000000, $
If I can't position the totals could I hide the detail display of Applied, Accepted and Denied and only show them in the subtotal and total rows all on one line rather than a line for the word "Total" and a second line for the actual totals?
TABLE FILE SQLOUT
PRINT
ID
NAME
ACADEMIC_PERIOD
COLLEGE
CAMPUS
PROGRAM
APPLICATION_DATE/HDMtYY-
LATEST_DECISION
LATEST_DECISION_DESC
LATEST_DECISION_DATE/HDMtYY-
SPRHOLD_REASON
FAFSA_RECEIVED
APPLIED/I5
ACCEPTED/I5
DENIED/I5
BY LOWEST PROGRAM NOPRINT
ON PROGRAM SUBTOTAL AS '*TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END
This message has been edited. Last edited by: Kerry,
WebFocus 7.7.03 Win7, all output
October 07, 2011, 07:26 PM
njsden
You cannot really alter positions of fields in a COLUMN-TOTAL or SUMMARIZE. They are designed to display on the very same column whose total they represent.
For the layout you want you will need to use either a FOOTING or a TABLE SUBFOOT.
Using SUBFOOT, there are a few options. Here is one using HEADALIGN=BODY:
-* File sxschech01.fex
DEFINE FILE CAR
DUM/A1=' ';
END
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
SALES
COMPUTE ONE/I5 = 1; NOPRINT
BY DUM NOPRINT
BY LOWEST COUNTRY
BY LOWEST CAR
BY LOWEST BODYTYPE
ON COUNTRY SUBFOOT
"Total<COUNTRY<ST.ONE Dealer:<ST.DEALER"
" <+0> <+0> <+0> Retail:<ST.RETAIL"
" <+0> <+0> <+0> Sales:<ST.SALES"
" "
ON DUM SUBFOOT
"Grand Total<+0> <ST.ONE Dealer:<ST.DEALER"
" <+0> <+0> <+0> Retail:<ST.RETAIL"
" <+0> <+0> <+0> Sales:<ST.SALES"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=SUBFOOT, HEADALIGN=BODY,
$
TYPE=SUBFOOT, ITEM=5, JUSTIFY=RIGHT,
$
ENDSTYLE
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
October 12, 2011, 07:48 PM
sxschech
Thanks Daniel,
Was able to use your code as a guide to make some progress in producing the report. Couple of questions, the totals were coming out with decimals even though the source data does not contain decimals and I did APPLIED/I5.
I was able to get the totals to show without decimals by doing a COMPUTE APPLIED_INT/I5 = INT(APPLIED); NOPRINT
Applied:<ST.APPLIED_INT
For some reason, the totals are aligning left justified even though the code you provided had JUSTIFY=RIGHT
Example: 10 22 4
Rather than 10 22 04
The leading zero doesn't exist on the report, only put in since I can't tell if display will line up after this is posted.
WebFocus 7.7.03 Win7, all output
October 14, 2011, 12:01 PM
sxschech
I figured out how to get the "Total" and totals to appear on one line rather than wrapping and taking 3 lines. I noticed that the Summary report doesn't wrap, while the detail report wraps. I turned the detail report into a summary by deleting the ID, Name, etc. and noticed that the Total now appeared as one line without wrapping. I then started adding back in the detail fields one by one and the Total remained on one line. Not knowing what was causing the report to now work, switched to the code view and compared the code between the original version and the revised version and the difference between the two was that the original version used the keyword "PRINT" while the revised version used the keyword "SUM".
Still would be curious about the version using subfoot layout getting the numbers to right justify, but the above will meet the needs for this report for now.