Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

I have a report that has some aggregated data from several c...


Russian Wyatt 2

Recommended Posts

I have a report that has some aggregated data from several companies on it. In the header of the report is the company name based on the users filter selection. Is it possible to create a drill-down link from there to a secondary report that uses the company name

The filter parameters of the main report are:

 

Company Name (required)

Program Name (required)

 

The filter parameters of the secondary report are:

 

Company Name (required)

Program Name (required)

Employee ID (optional)

Link to comment
Share on other sites

Hi Russian

I did the following in app studio I could not build it with InfoAssist.

TABLE FILE CAR

SUM

CAR.BODY.SALES

BY CAR.ORIGIN.COUNTRY

BY CAR.COMP.CAR

ON TABLE SUBHEAD

"<CAR.ORIGIN.COUNTRY "

WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(OR(FIND CAR.ORIGIN.COUNTRY IN CAR|FORMAT=A10)).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 = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,

$

TYPE=TABHEADING,

DRILLMENUITEM=DrillDown 1,

FOCEXEC=IBFS:/WFC/Repository/wf82retail/Report1.fex(

COUNTRY=&COUNTRY

),

TARGET=_blank,

$

ENDSTYLE

END

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...