Focal Point
[SOLVED by case] Bursting a Drill Through Report in Report Caster

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3697039295

November 03, 2010, 12:32 PM
Arif
[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,


WebFOCUS 7.6.10
Windows
HTML
November 03, 2010, 01:09 PM
Arif
First of all I should ask if drillthrough can be bursted?
Just got the answer to this question:
http://techsupport.information...om/sps/30542542.html

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


WebFOCUS 7.6.10
Windows
HTML
November 04, 2010, 08:16 AM
Hayley Gowan
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.


WebFOCUS 7.6.10
Windows
HTML