Drilling Down From a MR Procedure to a Procedure on the Server

In this section:

How to:

You can drill down from a procedure (Standard Report or Custom Report) in Managed Reporting to a procedure in an application namespace on the APP PATH of the WebFOCUS Reporting Server. This technique is also available for self-service applications.

Note: This technique should not be used in a Reporting Object if the user will use it for ad hoc reporting.

Top of page
x
Syntax: How to Drill Down From a Managed Reporting Procedure to a Procedure on the WebFOCUS Reporting Server
-SET &FOCEXURL='/ibi_apps/WFServlet?' | '&'; 
-SET &FOCEXURL=&FOCEXURL | 'IBIAPP_app=app_name' | '&'
SET FOCEXURL=&FOCEXURL
{TABLE|GRAPH} FILE filename
commands 
ON TABLE SET STYLE *
TYPE=type, [subtype], FOCEXEC=proc_name[(parameters ...)], $
ENDSTYLE
END

where:

app_name

Is the application name on the WebFOCUS Reporting Server.

filename

Specifies a data source.

commands

Are commands allowed in a procedure.

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 the Creating Reports With WebFOCUS Language manual.

proc_name

Is the name of the procedure. You must use the WebFOCUS file name.

To determine the WebFOCUS file name, right-click the report name and select Properties. The file name appears under Filename. Do not include the file extension (.fex) or the directory location and slash (/).

parameters

Values that are passed to the procedure.

Example: Drilling Down From a Managed Reporting Procedure to a Procedure on the WebFOCUS Reporting Server

The following illustrates how to drill down from a Managed Reporting procedure to a procedure located on the WebFOCUS Reporting Server.

Main report (main.fex, located in the Standard Reports folder of a domain): 

-SET &FOCEXURL='/ibi_apps/WFServlet?' | '&'; 
-SET &FOCEXURL=&FOCEXURL | 'IBIAPP_app=ibinccen' | '&'
SET FOCEXURL=&FOCEXURL
TABLE FILE CENTHR
PRINT START_DATE PAYSCALE POSITION
BY FULLNAME
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
GRID=OFF, $
TYPE=DATA, COLUMN=N4, FOCEXEC=drilldow (DESC=POSITION)
,
$
ENDSTYLE
END

Drill-down report (drilldow.fex, located on the WebFOCUS Reporting Server): 

TABLE FILE CENTHR
SUM POSITION_DESC
WHERE POSITION = '&DESC';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
GRID=OFF, $
END

The output is:

Output image

If you click on TR, a report with the position description opens.

TR report position description

Top of page
x
Creating Drill Downs to Managed Reporting Procedures That Run on Different Servers

When creating a drill down to a Managed Reporting procedure that runs on a different Reporting Server than the server that runs the report containing the drill down, you must explicitly specify the server for the drill down procedure in the procedure properties or in the domain properties. For example, if you have two Managed Reporting reports with the following properties:

When Report1 is executed and the drill-down to Report2 is clicked, WebFOCUS runs Report2 on Server B.

If a server is not explicitly set for the drill-down procedure (by not selecting the Server check box) in the procedure or domain properties, the procedure runs on the same server that runs the report containing the drill-down. For example, if you have two Managed Reporting reports with the following properties:

When Report1 is executed and the drill-down to Report2 is clicked, WebFOCUS runs Report2 on Server A.

WebFOCUS