[SOLVED] RECOMPUTE &SUBTOTAL not working in caster Job 77.03

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, 2005

Ignored post by Francis Mariani posted

Virtuoso

posted

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, 2005

Ignored post by njsden posted

Guru

posted

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, 2010

Ignored post by Arif posted

Guru

posted

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, 2010

Ignored post by Arif posted

Virtuoso

posted

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, 2005

Ignored post by njsden posted

Virtuoso

posted

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, 2005

Ignored post by njsden posted

Guru

posted

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, 2010

Ignored post by Arif posted

Virtuoso

posted

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, 2005

Ignored post by njsden posted

Guru

posted

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, 2010

Ignored post by Arif posted

Guru

posted

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, 2010

Ignored post by Arif posted

Virtuoso

posted

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, 2005

Ignored post by njsden posted

Guru

posted

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, 2010

Ignored post by Arif posted

Virtuoso

posted

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, 2005

Ignored post by njsden posted

Guru

posted

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, 2010

Ignored post by Arif posted