Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2009Report 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.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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, 2009Report 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.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders