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] RECOMPUTE &SUBTOTAL not working in caster Job 77.03

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] RECOMPUTE &SUBTOTAL not working in caster Job 77.03
 Login/Join
 
Guru
posted
We recently upgraded our environment to 7.7.03 from 7.6.10. We noticed today that all the library reports are miscalculating subtotals and providing column totals instead of subtotals. has anyone seen this issue before?

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


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Expert
posted Hide Post
I would create a simple report with subtotals using the CAR file to see if the issue is subtotals or something else. The opposite of the process of elimination: start with the minimum, then add more options until it breaks.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
Does the same happen if you distribute the reports using other mechanisms such as email?

How about when you run the reports directly without Report Caster's intervention?

Could you make an example using the CAR table including COMPUTES and a RECOMPUTE total line similar to yours so I can test in my local environment with and without Report Caster?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Guru
posted Hide Post
I will test simple report that is a good idea. It doesnt happen with live report. howver, I will test email and FTP distribution with this report also and update you guys.

Arif


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Guru
posted Hide Post
Car file works fine with computes and recomputes. I am not sure what am I doing wrong in my code. It used to work okay in 7.6.10.
JOIN
 STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID IN STAGE_CHILDDETAIL_POS
 TO UNIQUE DIM_SCHOOL.DIM_SCHOOL.SCHOOLID IN DIM_SCHOOL TAG J0 AS J0
 END
JOIN
 STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WEEKENDINGDATE IN
STAGE_CHILDDETAIL_POS TO UNIQUE DIM_TIME.DIM_TIME.DAYBEGINTIME IN DIM_TIME
 TAG J1 AS J1
 END
-*-SET &Cmt1 = IF &DSTJOBID.EXISTS THEN '' ELSE '-*';
-*-SET &Cmt2 = IF NOT &DSTJOBID.EXISTS THEN '' ELSE '-*';
TYPE REPORTSORT = &BURST.(<District,DistrictID>,<School,SchoolID>).
-*-SET &Cmt3 = IF &BURST EQ 'DistrictID' THEN '' ELSE '-*';
-RUN
-*SET BYDISPLAY = ON
DEFINE FILE STAGE_CHILDDETAIL_POS
Year/A4=EDIT( J1.DIM_TIME.FYPW,'9999$$$');
Period/A2=EDIT( J1.DIM_TIME.FYPW,'$$$$99$');
Week/A1=EDIT( J1.DIM_TIME.FYPW,'$$$$$$9');
END
TABLE FILE STAGE_CHILDDETAIL_POS
SUM
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLEDACTIVE' AS 'Active'
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLEDUNSCHEDULED' AS 'Unschded'
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.NEWENROLL' AS 'New'
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WITHDRAW' AS 'Termed'
     COMPUTE M/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.MONDAY * 5;
     COMPUTE T/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.TUESDAY * 5;
     COMPUTE W/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WEDNESDAY * 5;
     COMPUTE TH/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.THURSDAY * 5;
     COMPUTE F/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.FRIDAY * 5;
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.TOTALFTEWEEK/P8.1' AS 'FTE'
BY &BURST NOPRINT
BY HIGHEST 1 WEEKENDINGDATE NOPRINT
BY 'J0.DIM_SCHOOL.DIVISIONNAME' AS 'Division'
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS 'District'
BY 'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID' AS 'School'
-*&Cmt1.EVAL

ON DISTRICTNAME SUBTOTAL AS 'Total for: '
HEADING
"Enrollment Summary by School"
"FY <MAX.J1.DIM_TIME.Year Period <MAX.J1.DIM_TIME.Period Week <MAX.J1.DIM_TIME.Week"
FOOTING
"Produced on <+0>&DATEMDYY <+0> "
"Report ID: 1116"
WHERE J0.DIM_SCHOOL.SCHOOL_STATUS IN ('I','O');
-*&Cmt2.EVAL WHERE STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.FYPW EQ '&FYPW.(FIND FYPW,STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.FYPW IN stage_childdetail_pos).FYPW.';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>,<HTML Active Report,AHTML>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=DATA,
     COLUMN=N14,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N13,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N12,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N11,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N10,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N9,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N8,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N7,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N6,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N5,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N4,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N3,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=DATA,
     COLUMN=N1,
     BACKCOLOR=( 'WHITE' RGB(204 255 204) ),
$
TYPE=TITLE,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N3,
     JUSTIFY=LEFT,
$
TYPE=TITLE,
     COLUMN=N2,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=16,
     COLOR='BLUE',
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END
  


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Virtuoso
posted Hide Post
ON DISTRICTNAME SUBTOTAL AS 'Total for: '


Arif, you re not using RECOMPUTE. You have a regular SUBTOTAL in your line. What exactly do you expect to see as results?

Could you run this report with -SET &ECHO=ON; and post the code *after* all Dialogue Manager stuff has been resolved? Without knowing your data or parameters the code it's hard to follow ....



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Virtuoso
posted Hide Post
I really don't see anything "fishy" in your code except for the fact that you're using a SUBTOTAL instead of a RECOMPUTE so I am not sure that the total values you'll get for M, T, W, TH and F are correct.

My only concern is that if the very same code gives you different results in 7.6.10 vs. 7.7.03 then something is not adding up (so to speak). Hopefully there are no hidden SET'tings doing magic behind the scenes.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Guru
posted Hide Post
I am sorry i should have mentioned that I have tried both RECOMPUTE and subtotals but when i caster and burst this reprot, i am getting grand total of the einter column (company total) not sub totals.

so here is brief summary of the problem:

When i run this report live, everything works fine. I get subtotals by district.

when i run this report using report caster, I get company totals in subtoal section after every district. i have tried to reproduce this problem using the car file but i am not able to reproduce this problem using the car file because everything seems to be working when i use car file (subtotals and recomputes)


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Virtuoso
posted Hide Post
I noticed a &BURST variable in your code. Are you using the Burst functionality in Report? Which value are you passing to &BURST when you run the schedule?

If you are indeed using burst reports, you may be getting just one "piece" of it and that SUBTOTAL you are seeing may look like a report total just because that's all that shows up for the particular BURST value in place. Just something to keep in mind; it may not be the case at all.


That's why I suggested that you enabled -SET &ECHO=ON and showed us the code with all Dialogue Manager stuff out of the way. It may be a bit easier to debug that way (the style sheet declaration adds no value either).


Does this code relatively mimic yours:

TABLE FILE CAR
SUM 
        DEALER_COST AND RETAIL_COST
COMPUTE M/P8.1 = DEALER_COST * 5;
COMPUTE T/P8.1 = RETAIL_COST * 5;
COMPUTE W/P8.1 = (RETAIL_COST - DEALER_COST) * 5;
BY COUNTRY NOPRINT
BY CAR
BY MODEL
HEADING
"Sales"
ON CAR SUBTOTAL AS 'Total for '
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>,<HTML Active Report,AHTML>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, BORDER=LIGHT, $
TYPE=SUBTOTAL, BACKCOLOR='SILVER', $
ENDSTYLE
END



Please adjust it if needed, try it and let us know about your findings.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Guru
posted Hide Post
Yes I am bursting this report by DistrictID and Car file code works great when i burst call file with following code. Both recompute and subtotal work in car file

 
DEFINE FILE CAR
DISTRICTID/A5 = IF COUNTRY EQ 'ENGLAND' THEN '8165' ELSE
                IF COUNTRY EQ 'FRANCE'  THEN '8170' ELSE
IF COUNTRY EQ 'ITALY'   THEN '8176' ELSE
IF COUNTRY EQ 'JAPAN'   THEN '3021' ELSE '8000';
END

TABLE FILE CAR
SUM
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
BY  &BURST NOPRINT
BY  CAR.ORIGIN.DISTRICTID
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR

ON CAR.ORIGIN.DISTRICTID RECOMPUTE AS '*TOTAL'
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
END
 

I will turn echo on and test my orignal procedure and post update


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Guru
posted Hide Post
I still dont see anything in the trace that can cause this issue. It seems like some problem in the report caster.
 
Schedule Executed Due To NEXTRUNTIME at C15088IBIPROD:8200 
   Starting task: Task 1 
   Task type: MR Standard Report 
   Task domain: develope/develope.htm 
   Retrieving MR report: app/car 
   Connecting to server EDASERVE with execution id ibiadmin 
   Executing focexec. 
   JOIN 
   STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID IN STAGE_CHILDDETAIL_POS 
   TO UNIQUE DIM_SCHOOL.DIM_SCHOOL.SCHOOLID IN DIM_SCHOOL TAG J0 AS J0 
   END 
   JOIN 
   STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WEEKENDINGDATE IN 
   STAGE_CHILDDETAIL_POS TO UNIQUE DIM_TIME.DIM_TIME.DAYBEGINTIME IN DIM_TIME 
   TAG J1 AS J1 
   END 
   TABLE FILE STAGE_CHILDDETAIL_POS 
   SUM 
   'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLEDACTIVE' AS 'Active' 
   'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLEDUNSCHEDULED' AS 'Unschded' 
   'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.NEWENROLL' AS 'New' 
   'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WITHDRAW' AS 'Termed' 
   'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.TOTALFTEWEEK/P8.1' AS 'FTE' 
   BY DISTRICTID NOPRINT 
   BY HIGHEST 1 WEEKENDINGDATE NOPRINT 
   BY 'J0.DIM_SCHOOL.DIVISIONNAME' AS 'Division' 
   BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS 'District' 
   BY 'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID' AS 'School' 
   ON DISTRICTID SUBTOTAL 
   HEADING 
   FOOTING 
   WHERE J0.DIM_SCHOOL.SCHOOL_STATUS IN ('I','O'); 
   ON TABLE SET PAGE-NUM OFF 
   ON TABLE NOTOTAL 
   ON TABLE PCHOLD FORMAT PDF 
   ON TABLE SET HTMLCSS ON 
   ON TABLE SET STYLE * 
   UNITS=IN, 
   SQUEEZE=ON, 
   ORIENTATION=LANDSCAPE, 
   TYPE=REPORT, 
   GRID=OFF, 
   FONT='ARIAL', 
   SIZE=9, 
   ENDSTYLE 
   END 
   SET DISTRIBUTE=OFF 
   WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT 
   WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT 
   0 HOLDING PDF FILE ON PC DISK ... 
   Task finished. 
   Value: 8151 distributed to ReportLibrary (R16dmfp3lt54_31) with the group id R16dmfp3lt54 at the version 31 
   Value: 8152 distributed to ReportLibrary (R16dmfp3lt55_31) with the group id R16dmfp3lt55 at the version 31 
   Value: 8153 distributed to ReportLibrary (R16dmfp3r856_31) with the group id R16dmfp3r856 at the version 31 
   Value: 8154 distributed to ReportLibrary (R16dmfp3t757_31) with the group id R16dmfp3t757 at the version 31 
   Value: 8155 distributed to ReportLibrary (R16dmfp3t758_31) with the group id R16dmfp3t758 at the version 31 
   Value: 8156 distributed to ReportLibrary (R16dmfp3tn59_31) with the group id R16dmfp3tn59 at the version 31 
   Value: 8157 distributed to ReportLibrary (R16dmfp3tn60_31) with the group id R16dmfp3tn60 at the version 31 
   Value: 8159 distributed to ReportLibrary (R16dmfp3tn61_31) with the group id R16dmfp3tn61 at the version 31 
   Value: 8161 distributed to ReportLibrary (R16dmfp3v662_31) with the group id R16dmfp3v662 at the version 31 
   Value: 8162 distributed to ReportLibrary (R16dmfp3v663_31) with the group id R16dmfp3v663 at the version 31 
   Value: 8163 distributed to ReportLibrary (R16dmfp3vl64_31) with the group id R16dmfp3vl64 at the version 31 
   Value: 8164 distributed to ReportLibrary (R16dmfp3vl65_31) with the group id R16dmfp3vl65 at the version 31 
   Value: 8165 distributed to ReportLibrary (R16dmfp3vl66_31) with the group id R16dmfp3vl66 at the version 31 
   Value: 8168 distributed to ReportLibrary (R16dmfp40567_31) with the group id R16dmfp40567 at the version 31 
   Value: 8170 distributed to ReportLibrary (R16dmfp40568_31) with the group id R16dmfp40568 at the version 31 
   Value: 8173 distributed to ReportLibrary (R16dmfp40569_31) with the group id R16dmfp40569 at the version  
 


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Virtuoso
posted Hide Post
Arif, the code you are displaying in the report caster log is not consistent with the one you originally posted. Well, that's beyond the point. Could you put the result set you are getting with one of the reports (hiding any meaningul data of course) in comparison to what you expect to see as a result given the same data?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Guru
posted Hide Post
I had removed computes from the report code to test if computes were causing subtotal issue. but it seems like its report caster that is causing this issue for this report. here is the updated code:
 -SET &ECHO=ON;
JOIN
 STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID IN STAGE_CHILDDETAIL_POS
 TO UNIQUE DIM_SCHOOL.DIM_SCHOOL.SCHOOLID IN DIM_SCHOOL TAG J0 AS J0
 END
JOIN
 STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WEEKENDINGDATE IN
STAGE_CHILDDETAIL_POS TO UNIQUE DIM_TIME.DIM_TIME.DAYBEGINTIME IN DIM_TIME
 TAG J1 AS J1
 END
-*DEFINE FILE STAGE_CHILDDETAIL_POS
-*Year/A4=EDIT( J1.DIM_TIME.FYPW,'9999$$$');
-*Period/A2=EDIT( J1.DIM_TIME.FYPW,'$$$$99$');
-*Week/A1=EDIT( J1.DIM_TIME.FYPW,'$$$$$$9');
-*-*M/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.MONDAY * 5;
-*-*     T/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.TUESDAY * 5;
-*-*     W/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WEDNESDAY * 5;
-*-*     TH/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.THURSDAY * 5;
-*-*     F/P8.1 = STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.FRIDAY * 5;
-*END


TABLE FILE STAGE_CHILDDETAIL_POS
SUM
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLEDACTIVE' AS 'Active'
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLEDUNSCHEDULED' AS 'Unschded'
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.NEWENROLL' AS 'New'
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WITHDRAW' AS 'Termed'

-* M
-* T
-* W
-*TH
-*F
     'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.TOTALFTEWEEK/P8.1' AS 'FTE'
BY &BURST NOPRINT
BY HIGHEST 1 WEEKENDINGDATE NOPRINT
BY 'J0.DIM_SCHOOL.DIVISIONNAME' AS 'Division'
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS 'District'
BY 'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID' AS 'School'

ON DISTRICTID SUBTOTAL
HEADING
-*"Enrollment Summary by School"
-*"FY <MAX.J1.DIM_TIME.Year Period <MAX.J1.DIM_TIME.Period Week <MAX.J1.DIM_TIME.Week"
FOOTING
-*"Produced on <+0>&DATEMDYY <+0> "
-*"Report ID: 1116"
WHERE J0.DIM_SCHOOL.SCHOOL_STATUS IN ('I','O');

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,

ENDSTYLE
END

 


I have no issue when I run this report live; however, when I caster this job. My subtotals are not coming out correctly. Subtotals are coming out as grand totals of columns instead of subtotal.


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Virtuoso
posted Hide Post
Arif, if you cannot replicate this behaviour with the CAR table (or any other IBI-supplied file) I don't think we will be able to do it either and see the wrong results you describe. I would advise that you contact Tech Support on this one and let us know what the outcome is.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Guru
posted Hide Post
Problem solved.
It was by HIGHEST 1 WEEKENDING DATE;
I had to take the qweekending value in variable and use where statement for caster jobs. I had to do it for several reports that were used to burst at different levels.


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] RECOMPUTE &SUBTOTAL not working in caster Job 77.03

Copyright © 1996-2020 Information Builders