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] MAX DATE HEADER

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] MAX DATE HEADER
 Login/Join
 
Arif
Guru
posted
I am using MAX WEEKENDing date in my header information in one report it works, but it doesnt work in other report. Why different behavior for same data field in two different reports?
This works

"Learning Care Group AR Report Weekending :
This Doesnt Work

HEADING
"

Arif

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
<JG>
posted
post the code between code tags.
 
Report This Post
Arif
Guru
posted Hide Post
Note Working

"Learning Care Group Weekending :
-* Working
"Weekending :


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Arif
Guru
posted Hide Post

"Weekending : <\>


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Arif
Guru
posted Hide Post
  <MAX.HIREDATE> </1"


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
GamP
Virtuoso
posted Hide Post
It would help a lot if you put in the rest of the code also.
There must be something in your code that explains why there is a difference, but from just these two lines we can't tell one from the other.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Arif
Guru
posted Hide Post
 TABLE FILE AGG_ARBYSCHOOL
SUM 
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY0TO29DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY30TO59DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY60TO89DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY90TO119DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCYOVER120DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALAGENCYDEBIT/P9' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALUNRECONCILED/P7' AS '' OVER 
     COMPUTE NEWCOL/D6.1% = ( 0TO6DEBIT * 100 / TOTALSPONSORDEBIT ); AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 7TO13DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 14TO20DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 21TO27DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * OVER28DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * TOTALSPONSORDEBIT ) / TOTALSPONSORDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY0TO29DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY30TO59DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY60TO89DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY90TO119DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCYOVER120DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * TOTALAGENCYDEBIT ) / TOTALAGENCYDEBIT;
 AS ''
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS ''
BY 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.SCHOOLID' NOPRINT
BY 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.SCHOOLID' AS ''
     
ON J0.DIM_SCHOOL.DISTRICTNAME SUBTOTAL
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY0TO29DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY30TO59DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY60TO89DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY90TO119DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCYOVER120DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALAGENCYDEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALUNRECONCILED' AS 'Total'
HEADING
"Accounts Receiveable By School"
"<MAX.WEEKENDING></1"
" "
"                                  Private                                                                                         Agency"
"                                  Pay                                                                                               Pay"
" "
" <+0>District <+0>    School            <+0>  0-6 <+0>     <+0>    7-13 <+0>     14-20 <+0>     21-27    <+0>     28+  <+0>   Total <+0>        0-29       30-59      60-89 <+0>      90-119<+0>       120+  <+0>  Total  <+0>    UNREC "
FOOTING
"Run Date <+0>&DATE <+0> <+0>                                                                                                                                                     Page<TABPAGENO of <TABLASTPAGE"
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.055556,
     RIGHTMARGIN=0.055556,
     TOPMARGIN=0.041667,
     BOTTOMMARGIN=0.041667,
     SQUEEZE=0.541667,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=DATA,
     JUSTIFY=RIGHT,
$
TYPE=DATA,
     COLUMN=N16,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N17,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N18,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N19,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N20,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N21,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N28,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N29,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N30,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N31,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N32,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N33,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N22,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N23,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N24,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N27,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N25,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N26,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N1,
     JUSTIFY=LEFT,
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=LEFT,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N16,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N17,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N18,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N19,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N20,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N21,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N28,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N29,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N30,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N31,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N32,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N33,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N22,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N23,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N24,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N27,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N25,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N26,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N3,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N4,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N5,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N6,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N7,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N8,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N9,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N10,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N11,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N12,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N13,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N14,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N15,
     JUSTIFY=RIGHT,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-BOTTOM=LIGHT,
     SIZE=12,
     STYLE=BOLD,
     HEADALIGN=BODY,
$
TYPE=HEADING,
     LINE=4,
     COLSPAN=7,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     SIZE=10,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N16,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N17,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N18,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N19,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N20,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N21,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N28,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N22,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N23,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N24,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N27,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N25,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N26,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=1.055556,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N2,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N3,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N4,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N5,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N6,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N7,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N8,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N9,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N10,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N11,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N12,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N13,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N14,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
ENDSTYLE
END


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
GamP
Virtuoso
posted Hide Post
I take it, that this is the 'not-working' code.
If so, then it is not surprising that it does not work, because you reference a field in the heading that is not mentioned in the body of the report.
You should add a SUM MAX.WEEKENDING NOPRINT in the top of your TABLE.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Doug
Expert
posted Hide Post
Good Catch GamP...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Arif
Guru
posted Hide Post
Thank you for answering back. It still doesnt work. In one of my codes where it is working, I dont ahve max date in the body of the code.

Also, I am just stuggling with MAX/MIN dates. Most of my reports reuire MAX dates in headers and for the current week(Where EQ MAX.week). I am just surprised that date functions and options are not too flexible in webfocus. I can write these quries in SQL so easily. Any suggesions or help will be greatly appriciated.


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
GinnyJakes
Expert
posted Hide Post
Here is an example of what GamP is talking about:
TABLE FILE EMPLOYEE
SUM MAX.HIRE_DATE NOPRINT
PRINT EMP_ID HIRE_DATE
HEADING
"<MAX.HIRE_DATE"
END


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Arif
Guru
posted Hide Post
Ginny,
Thank you for helping. It is still not working for me. I have tried several things. When I run your code, it works; however when i use your code in my report referenceing my field name, it doesnt work. My datatype in the table is date.
New Code
 TABLE FILE AGG_ARBYSCHOOL
SUM MAX.WEEKENDING NOPRINT
SUM 

     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT/P5' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY0TO29DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY30TO59DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY60TO89DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY90TO119DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCYOVER120DEBIT/P7' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALAGENCYDEBIT/P9' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALUNRECONCILED/P7' AS '' OVER 
     COMPUTE NEWCOL/D6.1% = ( 0TO6DEBIT * 100 / TOTALSPONSORDEBIT ); AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 7TO13DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 14TO20DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 21TO27DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * OVER28DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * TOTALSPONSORDEBIT ) / TOTALSPONSORDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY0TO29DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY30TO59DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY60TO89DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY90TO119DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCYOVER120DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * TOTALAGENCYDEBIT ) / TOTALAGENCYDEBIT;
 AS ''
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS ''
BY 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.SCHOOLID' AS ''



ON J0.DIM_SCHOOL.DISTRICTNAME SUBTOTAL
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY0TO29DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY30TO59DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY60TO89DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY90TO119DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCYOVER120DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALAGENCYDEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALUNRECONCILED' AS 'Total'

	 
HEADING
"Accounts Receiveable By School"
"<MAX.WEEKENDING"
" "
"                                  Private                                                                                         Agency"
"                                  Pay                                                                                               Pay"
" "
" <+0>District <+0>    School            <+0> 0to6 <+0>     <+0>7to13 <+0>    14to20 <+0>    21to27    <+0>Over28  <+0> Tatal <+0>        0-29       30-59      60-89 <+0>      90-119<+0>       120+  <+0>  Total  <+0>     Unrec "

FOOTING
"Run Date <+0>&DATE <+0> <+0>                                                                                                                                                     Page<TABPAGENO of <TABLASTPAGE"
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.055556,
     RIGHTMARGIN=0.055556,
     TOPMARGIN=0.041667,
     BOTTOMMARGIN=0.041667,
     SQUEEZE=0.541667,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=DATA,
     JUSTIFY=RIGHT,
$
TYPE=DATA,
     COLUMN=N16,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N17,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N18,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N19,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N20,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N21,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N28,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N29,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N30,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N31,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N32,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N33,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N22,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N23,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N24,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N27,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N25,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N26,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N1,
     JUSTIFY=LEFT,
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=LEFT,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N16,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N17,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N18,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N19,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N20,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N21,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N28,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N29,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N30,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N31,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N32,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N33,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N22,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N23,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N24,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N27,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N25,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N26,
     FONT='ARIAL',
     SIZE=7,
     COLOR='BLUE',
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N3,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N4,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N5,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N6,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N7,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N8,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N9,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N10,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N11,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N12,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N13,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N14,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     COLUMN=N15,
     JUSTIFY=RIGHT,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-BOTTOM=LIGHT,
     SIZE=12,
     STYLE=BOLD,
     HEADALIGN=BODY,
$
TYPE=HEADING,
     LINE=4,
     COLSPAN=7,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     SIZE=10,
     BACKCOLOR='WHITE',
     STYLE=UNDERLINE,
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N16,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N17,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N18,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N19,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N20,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N21,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N28,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N22,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N23,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N24,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N27,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N25,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N26,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=1.055556,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N2,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N3,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N4,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N5,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N6,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N7,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N8,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N9,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N10,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N11,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N12,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N13,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=REPORT,
     COLUMN=N14,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
ENDSTYLE
END


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
GinnyJakes
Expert
posted Hide Post
What is the format of the WEEKENDING field?

BTW, you don't have to post your all of your stylesheet syntax as it is not pertinent to the discussion.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Hua
Guru
posted Hide Post
Numberic fields are aggregated on heading/subheads... I had the same problem before. see this post
Try use the alpha field to hold the max.weekending

Hua

This message has been edited. Last edited by: Hua,


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
Arif
Guru
posted Hide Post
My Field format is date (not datetime & Database is SQL 2008). Interestingly enough one of my reports using the same filed is able to print max date.


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Hua
Guru
posted Hide Post
Could it be single occurrance within the sort group, that makes it work?


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
Arif
Guru
posted Hide Post
YEs I think I am going to try to use this by created a hold table--> Sort Desending date--> Join it with my table and use the data from there. Thanks for the tip


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report 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] MAX DATE HEADER

Copyright © 1996-2020 Information Builders