I am trying to create a drilldown report such that clicking on report1 it drilldown to its value along with passing those parameter to report2 and it also get drilldown based on that parameter's value simultaneously. But I am not able to pass the parameter's value. Any suggestions or example would be a great help

This message has been edited. Last edited by: <Emily McAllister>,

Something like this, I venture

type=data, focexec=report2(ColumnParameter=ColumnName Parameter='&Parameter' ...)

Thanks Danny for your response. Tries that but couldn't make it.
Here is a simple example which can show exact what I want to do

TYPE=DATA,
DRILLMENUITEM='Model',
FOCEXEC=/WFC/Repository/Development/Test/TESTNOW/drilldown/New_Procedure.fex( \
carmodel=N2 \
),
TARGET='_self',
FOCEXEC=report2( \
carmodel=N2 \
),
TARGET='_self',
$



where carmodel is the parameter want to pass. And the first FOCEXEC is the report1 in which there is a drill menu and the other one is for report2 with the parameter carmodel of the report1 for the first drill down

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

Here are few post on this issue. First one shows an alternative option using JavaScript.

http://forums.informationbuild...917087676#3917087676

This has a lot of good examples.

http://forums.informationbuild...917087676#3917087676

Offical documentation.

http://infocenter.informationb...source%2Ftopic42.htm

quote:

kmvgt

Hi kmvgt,

I'm not clear on what you are trying to do.
Are you able to drill to the procedure under DRILLMENUITEM='Model',?

For report2 why do you not have a DRILLMENUITEM?

Sorry for not so clear regarding my question. I just want to do that clicking on the
DRILLMENUITEM='Model'

should execute two or more fex simultaneously passing the same parameter value.

So? What is your difficult kmvgt?

Here is an example:


car.fex

  
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/baseapp/Report2.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=DATA,
     COLUMN=N1,
     DRILLMENUITEM='Model',
          FOCEXEC=baseapp/car_a( \
     COUNTRY=N1 \
     ),
$
ENDSTYLE
END

car_a.fex

 
-INCLUDE baseapp/car_a2.fex
-INCLUDE baseapp/car_a1.fex
 

car_a1.fex

 
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/baseapp/Report2.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
BY  CAR.ORIGIN.COUNTRY
BY  CAR.CARREC.MODEL
WHERE CAR.ORIGIN.COUNTRY EQ '&COUNTRY';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

 

car_a2.fex

-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/baseapp/Report2.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
     CAR.SPECS.LENGTH
     CAR.SPECS.WIDTH
     CAR.SPECS.RPM
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.BODY.BODYTYPE
WHERE CAR.ORIGIN.COUNTRY EQ '&COUNTRY';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END