Emily Lee Posted October 27, 2021 Share Posted October 27, 2021 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 More sharing options...
VisuaLizeFOCUS . Posted October 28, 2021 Share Posted October 28, 2021 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 More sharing options...
Emily Lee Posted November 1, 2021 Author Share Posted November 1, 2021 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 More sharing options...
Alexander Homer Posted November 8, 2021 Share Posted November 8, 2021 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 More sharing options...
Emily Lee Posted November 9, 2021 Author Share Posted November 9, 2021 ALEX, Thank you very much. It works with TYPE=SUBTOTAL, OBJECT=TAG, BY=COUNTRY. This case can be set as RESOLVED. thanks, Emily Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now