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

I have an accordion report with 2 hierarchy levels Region/...


Emily Lee

Recommended Posts

I have an accordion report with 2 hierarchy levels Region/Product, how can I add the drilldown to the upper level column

I can add the drilldown to the lowest level - Product column, but the requirement for me is to add drilldown function to the upper level Region column. I cant make it work. Does anyone have good suggestion

Thank you.

Emily Lee

Link to comment
Share on other sites

I hope It helps:

TABLE FILE CAR

SUM

 

 

CAR.BODY.SEATS*

 

 

 

CAR.BODY.SALES*

 

 

 

BY CAR.ORIGIN.COUNTRY

BY CAR.COMP.CAR

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE SET EXPANDABLE ON

ON TABLE SET EXPANDBYROW OFF

ON TABLE SET EXPANDBYROWTREE OFF

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=DATA,

 

 

COLUMN = N1,*

 

 

DRILLMENUITEM='DrillDown 1',*

 

 

 

FOCEXEC=IBFS:/WFC/Repository/Time_pass/DRILL1.fex,*

 

 

 

TARGET='_blank',*

 

 

 

$

ENDSTYLE

END

 

image.png969624 33.3 KB

Link to comment
Share on other sites

Hi Rajesh,

Thank you very much for your suggestion.

When set ON TABLE SET EXPANDBYROW OFF, the result is Fig3, and Fig 4, and drilldown can set at the Country column, but that cannot meet our users requirement.

Our users want the initial HTML report shows the Grand total of each column rows for each Country, and also have a drilldown URL at the Country column to provide drilldown at to other report. See the Fig1, and Fig2. The command ON TABLE SET EXPANDBYROW ON is needed.

 

Accordion_drilldown.PNG888487 77.5 KB

Link to comment
Share on other sites

Hi Emily,

Data rows in an accordion EXPANDBYROWTREE report are actually subtotals, so you use the SUBTOTAL item in the StyleSheet instead of the DATA item. You can then use OBJECT=TAG to select only the subtotal title, which appears as the sort value.

TABLE FILE ibisamp/car

SUM CAR.BODY.DEALER_COST

CAR.BODY.RETAIL_COST

CAR.BODY.SALES

BY CAR.ORIGIN.COUNTRY

ON CAR.ORIGIN.COUNTRY SUBHEAD

"Click to view details for <COUNTRY"

BY CAR.COMP.CAR

BY CAR.CARREC.MODEL

ON TABLE PCHOLD FORMAT HTML

ON TABLE NOTOTAL

ON TABLE SET CACHELINES 100

ON TABLE SET GRWIDTH 1

ON TABLE SET EXPANDBYROWTREE 1

ON TABLE SET DROPBLNKLINE ON

ON TABLE SET STYLE *

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$

TYPE=REPORT,ORIENTATION=LANDSCAPE, $

TYPE=SUBTOTAL, BY=1, OBJECT=TAG, ALT='Drill to country', TARGET='_blank',

URL=https://en.wikipedia.org/w/index.php(title=CAR.ORIGIN.COUNTRY), $

ENDSTYLE

END

 

-RUN

 

The result appears as follows:

 

Thanks,

Alex

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...