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

[Emily Lee]

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

[VisuaLizeFOCUS .]

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

[Emily Lee]

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

[Alexander Homer]

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

[Emily Lee]

ALEX,

Thank you very much. It works with TYPE=SUBTOTAL, OBJECT=TAG, BY=COUNTRY.

This case can be set as RESOLVED.

thanks,

Emily