I'm not sure how drilldown works in WebFocus.
I wanna drilldown into a new page when I click on Region on my report.
I don't know how to incorporate that into my coding.

-SET &ECHO = ON;
SET EMPTYREPORT = ON
SET PAGE-NUM = OFF

-DEFAULT &BUDGET = '5000';
-DEFAULT &TBUDGET = '60000';
-DEFAULT &JBUDGET = '4000';
-DEFAULT &TJBUDGET = '48000';

JOIN PAYEEID IN EXPENSEBASE TO SYSTEMUSERID IN CRMSYSTEMUSER AS J1
-RUN

TABLE FILE EXPENSEBASE
PRINT
PAYEEID
FULLNAME
POSITION
EXPENSEDATE
COSTCENTER
EXPENSESTATUS
TOTALAMOUNT
COMPUTE BUDGET/D15.2M = &BUDGET;
COMPUTE VARIANCE/D15.2M = BUDGET - TOTALAMOUNT;
EXPENSEREGION
EXPENSETYPE
BY EXPENSEID
WHERE EXPENSEREGION NE 'GGOF';
WHERE EXPENSESTATUS EQ 'SUBMITTED';
WHERE EXPENSETYPE EQ 'NON_CONTACT';
WHERE COSTCENTER NE 'F7263' OR COSTCENTER IS MISSING;
WHERE PAYEEID NE '{8E0B13A0-35AA-DB11-9657-001438BFF493}' OR PAYEEID EQ '{D754F242-FE97-DA11-ABEB-001438BFF493}' OR
PAYEEID EQ '{AA3A710F-6322-DB11-8082-001438BFF493}' OR PAYEEID EQ '{60EC0DB1-9C46-DC11-9630-001438BFF493}' OR
PAYEEID EQ '{651BD212-4997-DA11-ABEB-001438BFF493}';
ON TABLE HOLD AS NONCONTACT
END
-RUN

TABLE FILE EXPENSEBASE
PRINT
PAYEEID
FULLNAME
POSITION
EXPENSEDATE
COSTCENTER
EXPENSESTATUS
TOTALAMOUNT
COMPUTE BUDGET/D15.2M = &BUDGET;
COMPUTE VARIANCE/D15.2M = BUDGET - TOTALAMOUNT;
EXPENSEREGION
EXPENSETYPE
BY EXPENSEID
WHERE COSTCENTER NE 'F7263' OR COSTCENTER IS MISSING;
WHERE POSITION IN ('RSM', 'ISR', 'SC');
WHERE EXPENSEREGION NE 'GGOF';
WHERE EXPENSETYPE EQ 'CONTACT';
WHERE EXPENSESTATUS EQ 'SUBMITTED';
WHERE PAYEEID NE '{8E0B13A0-35AA-DB11-9657-001438BFF493}' OR PAYEEID EQ '{D754F242-FE97-DA11-ABEB-001438BFF493}' OR
PAYEEID EQ '{AA3A710F-6322-DB11-8082-001438BFF493}' OR PAYEEID EQ '{60EC0DB1-9C46-DC11-9630-001438BFF493}' OR
PAYEEID EQ '{651BD212-4997-DA11-ABEB-001438BFF493}';
ON TABLE HOLD AS CONTACT
END
-RUN

TABLE FILE EXPENSEBASE
PRINT
PAYEEID
FULLNAME
POSITION
EXPENSEDATE
COSTCENTER
EXPENSESTATUS
TOTALAMOUNT
COMPUTE BUDGET/D15.2M = &BUDGET;
COMPUTE VARIANCE/D15.2M = BUDGET - TOTALAMOUNT;
EXPENSEREGION
EXPENSETYPE
BY EXPENSEID
WHERE POSITION EQ 'RSM';
WHERE EXPENSESTATUS EQ 'OPEN';
WHERE COSTCENTER NE 'F7263';
WHERE PAYEEID NE '{8E0B13A0-35AA-DB11-9657-001438BFF493}' OR PAYEEID EQ '{D754F242-FE97-DA11-ABEB-001438BFF493}' OR
PAYEEID EQ '{AA3A710F-6322-DB11-8082-001438BFF493}' OR PAYEEID EQ '{60EC0DB1-9C46-DC11-9630-001438BFF493}' OR
PAYEEID EQ '{651BD212-4997-DA11-ABEB-001438BFF493}';
ON TABLE HOLD AS OPENEXPRSM
END
-RUN

TABLE FILE EXPENSEBASE
PRINT
PAYEEID
FULLNAME
POSITION
EXPENSEDATE
COSTCENTER
EXPENSESTATUS
TOTALAMOUNT
COMPUTE BUDGET/D15.2M = &JBUDGET;
COMPUTE VARIANCE/D15.2M = BUDGET - TOTALAMOUNT;
COMPUTE EXPENSEREGION/A50 = 'John Boeckh';
EXPENSETYPE
BY EXPENSEID
WHERE PAYEEID EQ '{8E0B13A0-35AA-DB11-9657-001438BFF493}';
WHERE EXPENSEREGION NE 'GGOF';
ON TABLE HOLD AS JBEXPENSE
END
-RUN

TABLE FILE JBEXPENSE
PRINT *
ON TABLE HOLD AS EXPENSES
MORE
FILE OPENEXPRSM
MORE
FILE CONTACT
MORE
FILE NONCONTACT
END
-RUN

DEFINE FILE EXPENSES
EXPDATE_MMYY/MtYY = EXPENSEDATE;
JREGION/A50 = IF EXPENSEREGION EQ 'John Boeckh' THEN 'ZZZZZ' ELSE EXPENSEREGION;
END

TABLE FILE EXPENSES
SUM
TOTALAMOUNT/D15.2M/C AS 'Actual'
MAX.BUDGET/C AS 'Budget'
MAX.VARIANCE/C AS 'Variance'
BY JREGION NOPRINT
BY EXPENSEREGION AS 'Region'
ACROSS EXPDATE_MMYY AS ' ' ROW-TOTAL
WHERE EXPENSEREGION NE ' ';
ON TABLE COLUMN-TOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS = IN, PAGESIZE = LEGAL, ORIENTATION = LANDSCAPE, GRID = OFF, SQUEEZE = ON,
LEFTMARGIN = 0.5, TOPMARGIN = 0.25, RIGHTMARGIN = 0.025, BOTTOMMARGIN = 0.025, LEFTGAP = 0.055, RIGHTGAP = 0.055, $
TYPE = REPORT, FONT = 'Arial', SIZE = 9, $
TYPE = HEADING, SIZE = 9, STYLE = BOLD, $
TYPE = TITLE, SIZE = 9, STYLE = BOLD, $
TYPE = DATA, SIZE = 8, JUSTIFY = LEFT, COLUMN = EXPENSEREGION, BACKCOLOR = ( RGB(243 244 248) RGB(255 255 255) ), $
TYPE = DATA, SIZE = 8, JUSTIFY = RIGHT, BACKCOLOR = ( RGB(243 244 248) RGB(255 255 255) ), $
TYPE = ACROSS, FONT = 'ARIAL', SIZE = 9, STYLE = BOLD, JUSTIFY = CENTER, $
TYPE = GRANDTOTAL, FONT = 'ARIAL', SIZE = 8, STYLE = BOLD, $
TYPE = TITLE, COLUMN = ROWTOTAL(1), STYLE = BOLD, $
TYPE = TITLE, COLUMN = ROWTOTAL(2), STYLE = BOLD, $
TYPE = TITLE, COLUMN = ROWTOTAL(3), STYLE = BOLD, $
TYPE = DATA, COLUMN = ROWTOTAL(1), STYLE = BOLD, $
TYPE = DATA, COLUMN = ROWTOTAL(2), STYLE = BOLD, $
TYPE = DATA, COLUMN = ROWTOTAL(3), STYLE = BOLD, $
TYPE = ACROSSVALUE, COLUMN = ROWTOTAL(1), STYLE = BOLD, $
ENDSTYLE
END

Ggof,

Click the link in the top right (Search the Technical Doc Library) and within the next window choose the right hand search options choosing WebFOCUS forum and the search string "Controlling Drilldown" or just "Drilldown" and you should be able to see some examples.

From the help files in Dev Studio -

Syntax: How to Link to Reports and Procedures
TYPE=type, [subtype], FOCEXEC=fex[(parameters ...)], [TARGET=frame,] $where: 

type 

Identifies the report component that you select in the Web browser to execute the link. The TYPE attribute
and its value must appear at the beginning of the declaration.


subtype 

Are any additional attributes, such as COLUMN, LINE, or ITEM, that are needed to identify the report
component that you are formatting. For information on identifying report components, see Identifying a
Report Component in a WebFOCUS StyleSheet.


fex 

Identifies the file name of the linked procedure to run when you select the report component.


To determine the file name in WebFOCUS, see How to Determine a WebFOCUS File Name in Managed Reporting.
The file name in Developer Studio or in deployed self-service applications is the name of the procedure. 


The maximum length of a FOCEXEC=fex argument, including any associated parameters, is 2400 characters. The
FOCEXEC argument can span more than one line, as described in Creating and Managing a WebFOCUS StyleSheet.


parameters 

Values that are passed to the report, URL, or JavaScript function. For details, see Creating Parameters.


frame 

Identifies the target frame in the Web page in which the output from the drill-down link is displayed. For
details, see Specifying a Target Frame.

T

G,

Write your child or target report first with a WHERE clause that evaluates the region against an amper variable that you will be passing from the parent or calling report. Run it independently typing in a region to make sure that it works.

Then go back to the parent report and edit it and put the syntax in the stylesheet that Tony describes OR (I know you don't like the GUI but in this case it is really easy) go into the Report Painter, right-click on the region field, select Options, then the drilldown tab. Make sure you set the Active Object to Column Data. Then under Drilldown Type select Execute Procedure and follow the instructions from there.

Piece of cake.

G

it depends on what you want to get in your drill down report.
You start report has an across and by field and you can put your child report(s) on almost every piece of the parent report.
If you want to get a detailed report based on the cross from JREGION, EXPENSEREGION and EXPDATE_MMYY then you give these fields with the call of the new report.

Search here on this site for examples on how that works.
As Ginny said, piece of cake.