Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Across on two lines
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Across on two lines
 Login/Join
 
Member
posted
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
 
Posts: 21 | Registered: August 26, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 21 | Registered: August 26, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Across on two lines

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.