[SOLVED by case] Bursting a Drill Through Report in Report Caster
I have looked at the form about bursting drill through report. Also, I looked at reprot caster documentation it says PDF drillthough is supported. I am not sure if it is supported to be castered or bursted. I am not able to burst this report. I only have two parts in this report. Summary and detail. When I burst this report its only bursting the detail part of the report. Any one know what might be the trick here?
TABLE FILE STAGE_CHILDDETAIL_POS
SUM
'CNT.STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.CHILDLASTNAME' AS 'Child Count'
BY DISTRICTID NOPRINT
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS 'District'
BY 'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID' AS 'School'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=SCHOOLID, DRILLTHROUGH=DOWN(SCHOOLID=STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID),$
END
TABLE FILE STAGE_CHILDDETAIL_POS
PRINT
'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.Last' AS 'Last Name'
'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.First' AS 'First Name'
'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.ENROLLMENTDATE/HYYMD' AS 'Enrollment'
'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.WITHDRAWDATE/HYYMD' AS 'Withdraw'
BY DISTRICTID NOPRINT
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS 'District'
BY 'STAGE_CHILDDETAIL_POS.STAGE_CHILDDETAIL_POS.SCHOOLID' AS 'School ID'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=DATA,
COLUMN=SCHOOLID,
DRILLTHROUGH=FIRST(SCHOOLID),
$
END
This message has been edited. Last edited by: Kerry,
I need to clarify my question about conditional branching that came about rather oddly as a response under the topic of "Halloween Question".
How do I write the same type of GOTO logic, originally shown in that Dialog Manager example, but in a MF report (that has no input &variables)? Can I use something available like a defined or exiting field to test whether or not some condition occurs and then, based on that, go to the appropriate step label to handle only that kind of data? --- Think of old COBOL logic, perhaps. Are GOTO's in FOCUS used only in DM code?
WebFOCUS 7.6 Windows, All Outputs
November 08, 2010, 12:00 AM
Arif
I am not sure what you mean Hayley. I confirmed with TEch support at the moment drillthrough can not be bursted it can be castered though.