I'd like to create a report by school name, with an across of grade. But within the across I need to display attendance type totals on two separate lines.
The output should look something like:
Grade K 1 2 ... Total School Name 1 Enrolled 1243 999 1101 52307 Registered 1234 987 1098 52295
Here is the master file: FILENAME=ptbl_daily_enrollment, SUFFIX=SQLORA , $ SEGMENT=PTBL_DAILY_ENROLLMENT, SEGTYPE=S0, $ FIELDNAME=SIS_SCHOOL_YEAR, ALIAS=SIS_SCHOOL_YEAR, USAGE=I4, ACTUAL=D8, MISSING=ON, TITLE='School Year', $ FIELDNAME=SCHOOL_KEY, ALIAS=SCHOOL_KEY, USAGE=D20.2, ACTUAL=D8, MISSING=ON, DESCRIPTION='Primary key. Maps to dtbl_schools and dtbl_school_evolved.', $ FIELDNAME=SCHOOL_CODE, ALIAS=SCHOOL_CODE, USAGE=A10V, ACTUAL=A10V, MISSING=ON, DESCRIPTION='School Number', $ FIELDNAME=SCHOOL_NAME, ALIAS=SCHOOL_NAME, USAGE=A50V, ACTUAL=A50V, MISSING=ON, TITLE='School Name', DESCRIPTION='School Name', $ FIELDNAME=DAY_OF_SCHOOL, ALIAS=DAY_OF_SCHOOL, USAGE=I4, ACTUAL=D8, MISSING=ON, TITLE='School Day', DESCRIPTION='Numeric day of school (1,2,3,...,179,180)', $ FIELDNAME=DATE_OF_SCHOOL, ALIAS=DATE_OF_SCHOOL, USAGE=HYYMDS, ACTUAL=HYYMDS, MISSING=ON, TITLE='School Date', DESCRIPTION='Valid district-is-open date', $ FIELDNAME=GRADE, ALIAS=GRADE, USAGE=A5V, ACTUAL=A5V, MISSING=ON, TITLE='Grade', DESCRIPTION='Student Current Grade', $ FIELDNAME=STUDENT_SPECIAL_ED_CLASS, ALIAS=STUDENT_SPECIAL_ED_CLASS, USAGE=A50V, ACTUAL=A50V, MISSING=ON, DESCRIPTION='What is this students current special education classification? Unit (meaning special ed only courses ) or Non-Unit (meaning special ed integrated with non-special-ed courses/treatments. Students without a special education assignment are coded Not Special Ed', $ FIELDNAME=ENROLLED, ALIAS=ENROLLED, USAGE=I5, ACTUAL=D8, MISSING=ON, TITLE='Enrolled', DESCRIPTION='Count of enrolled students', $ FIELDNAME=REGISTERED, ALIAS=REGISTERED, USAGE=I5, ACTUAL=D8, MISSING=ON, TITLE='Registered', DESCRIPTION='Count of registered students', $ DEFINE SCHOOL_DATE/MDYY WITH SIS_SCHOOL_YEAR=HDATE(DATE_OF_SCHOOL, 'MDYY'); TITLE='School Date', $ DEFINE SIS_ENROLLED/I5 WITH SIS_SCHOOL_YEAR=ENROLLED + REGISTERED; TITLE='Enrolled', $
Could anyone share a strategy to accomplish this or point me to documentation, FocalPoint, Tech Support entries that might help. Any help is appreaciated!This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.11 Developer Studio on Windows XP. Server Components running on Windows Server 2003. Excel, HTML, PDF
October 05, 2010, 04:49 PM
Waz
Please post your code between the code tags.
Grade
K 1 2 ... Total
School Name 1 Enrolled 1243 999 1101 52307
Registered 1234 987 1098 52295
Try this:
TABLE FILE ptbl_daily_enrollment
PRINT ENROLLED AS STUDENT_CNT
COMPUTE TYPE/A10 = 'Enrolled' ;
BY SCHOOL_NAME
BY GRADE
ON TABLE HOLD AS TMP_SCHL FORMAT ALPHA
END
FILEDEF TMP_SCHL DISK tmp_schl.ftm (APPEND
TABLE FILE ptbl_daily_enrollment
PRINT REGISTERED AS STUDENT_CNT
COMPUTE TYPE/A10 = 'Registered' ;
BY SCHOOL_NAME
BY GRADE
ON TABLE HOLD AS TMP_SCHL FORMAT ALPHA
END
FILEDEF TMP_SCHL DISK tmp_schl.ftm
TABLE FILE TMP_SCHL
SUM STUDENT_CNT
BY SCHOOL_NAME
BY TYPE
ACROSS GRADE
END
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 06, 2010, 12:22 PM
redapple
Thanks WAZ!
A working example with my data to learn from. Couldn't ask for anything more!This message has been edited. Last edited by: redapple,
WebFOCUS 7.6.11 Developer Studio on Windows XP. Server Components running on Windows Server 2003. Excel, HTML, PDF
October 06, 2010, 04:16 PM
Waz
Taking and using an example is one thing, understanding what your given is another.