Focal Point
[SOLVED] Across on two lines

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/207105045

October 05, 2010, 10:06 AM
redapple
[SOLVED] Across on two lines
Hello All,

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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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.

Please make the time to understand the example.


Is that like "Give a man a fish...." ? Big Grin


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!