Focal Point
[CLOSED] EXPANDBYROW and Drillthrough

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2287065196

August 30, 2019, 09:11 AM
Greg_Coley
[CLOSED] EXPANDBYROW and Drillthrough
I'm having some trouble getting Drill-through to work while using EXPANDBYROW. Is there anything i'm missing about using them together ? The EXPANDBYROW works, but there are no links for the Drill-through. If i remove EXPANDBYROW, then the links show up and work as expected. See my Code Below:

 TABLE FILE SAP/DOLLAR_LIST/ZSD_DOLLAR_LIST
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
     COMPUTE Gross_Revenue_T;
     COMPUTE Discount_T;
     COMPUTE Discount_Perc;
     COMPUTE Net_Revenue_T;
     COMPUTE Cost_T;
     COMPUTE GM;
     COMPUTE GM_Perc;
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Division_Name
ON TABLE SUBHEAD
"GM per Customer"
"&Bill_Start_Date - &Bill_End_Date"
ON TABLE SUBFOOT
"*All dollar values listed in thousands of dollars"
WHERE ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Organization EQ 'US22' AND ( ZSD_DOLLAR_LIST.INTERCOMPANY_LIST.Intercompany_Std EQ &Intercompany_Std.(OR(<Intercompany,Intercompany>,<Standard,Standard>|FORMAT=A20)).Intercompany / Std.) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date GE &Bill_Start_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date Start:.QUOTEDSTRING ) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date LE &Bill_End_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date End:.QUOTEDSTRING ) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.ISDISCOUNT EQ &ISDISCOUNT.(OR(<Discounted,Discounted>,<Not Discounted,Not Discounted>|FORMAT=A20)).Discount:.) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Domestic_International EQ &Domestic_International.(OR(<Domestic,Domestic>,<International, International>|FORMAT=A20)).Domestic / International:.) AND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description EQ &Sales_Document_Description.(OR(FIND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description,ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description IN zsd_dollar_list|FORMAT=A20V)).Sales_Document_Description.;
ON TABLE SET GRWIDTH 1
ON TABLE SET EXPANDBYROW ON
ON TABLE SET AUTOFIT OFF
ON TABLE SET ASNAMES ON
ON TABLE RECOMPUTE AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET CACHELINES 100
ON TABLE SET HTMLEMBEDIMG ON
TYPE=DATA,
     COLUMN=N2,
     COLOR='WHITE',
     FOCEXEC=IBFS:/WFC/Repository/SAP/DOLLAR_LIST/GM_per_Customer_by_Order.fex( \
     Bill_End_Date=&Bill_End_Date.QUOTEDSTRING \
     Bill_Start_Date=&Bill_Start_Date.QUOTEDSTRING \
     Domestic_International=&Domestic_International.QUOTEDSTRING \
     Intercompany_Std=&Intercompany_Std.QUOTEDSTRING \
     ISDISCOUNT=&ISDISCOUNT.QUOTEDSTRING \
     Sales_Document_Description=&Sales_Document_Description.QUOTEDSTRING \
     Sold_To_Party_Name=N2 \
     ),
$
ENDSTYLE
END

I stripped as much as i could so it wouldn't be a wall of text here, hopefully i didn't omit anything that's causing the issue. Is it possible that my Multi-Verb is part of the problem ?

This message has been edited. Last edited by: FP Mod Chuck,


Greg Coley
August 30, 2019, 09:54 AM
BabakNYC
According to the manual:
  
The following requirements must be taken into consideration when creating Accordion Reports:

    Adding a drill-down link to an Accordion Report requires that the TARGET parameter must be set to a value that specifies a new HTML frame.


Can you try adding 
  , TARGET='_blank'

to your drill down?


WebFOCUS 8206, Unix, Windows
August 30, 2019, 02:07 PM
Greg_Coley
quote:
TARGET='_blank'

Thanks for the the info. However, i still get the same results. Code Below:
  
TABLE FILE SAP/DOLLAR_LIST/ZSD_DOLLAR_LIST
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
     COMPUTE Gross_Revenue_T;
     COMPUTE Discount_T;
     COMPUTE Discount_Perc;
     COMPUTE Net_Revenue_T;
     COMPUTE Cost_T;
     COMPUTE GM;
     COMPUTE GM_Perc;
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Division_Name
ON TABLE SUBHEAD
"GM per Customer"
"&Bill_Start_Date - &Bill_End_Date"
ON TABLE SUBFOOT
"*All dollar values listed in thousands of dollars"
WHERE ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Organization EQ 'US22' AND ( ZSD_DOLLAR_LIST.INTERCOMPANY_LIST.Intercompany_Std EQ &Intercompany_Std.(OR(<Intercompany,Intercompany>,<Standard,Standard>|FORMAT=A20)).Intercompany / Std.) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date GE &Bill_Start_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date Start:.QUOTEDSTRING ) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date LE &Bill_End_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date End:.QUOTEDSTRING ) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.ISDISCOUNT EQ &ISDISCOUNT.(OR(<Discounted,Discounted>,<Not Discounted,Not Discounted>|FORMAT=A20)).Discount:.) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Domestic_International EQ &Domestic_International.(OR(<Domestic,Domestic>,<International, International>|FORMAT=A20)).Domestic / International:.) AND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description EQ &Sales_Document_Description.(OR(FIND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description,ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description IN zsd_dollar_list|FORMAT=A20V)).Sales_Document_Description.;
ON TABLE SET GRWIDTH 1
ON TABLE SET AUTOFIT OFF
ON TABLE SET ASNAMES ON
ON TABLE RECOMPUTE AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET CACHELINES 100
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/WFC/Repository/SAP/DOLLAR_LIST/warm_IPEGEXPANDING.sty,
$
     ORIENTATION=LANDSCAPE,
     TITLETEXT='&WF_TITLE',
$
TYPE=REPORT,
     FONT='IBIDEFAULT',
     SIZE=12,
     COLOR=RGB(20 20 20),
     ARGRAPHENGINE=JSCHART,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(215 215 215),
     BORDER-BOTTOM-COLOR=RGB(215 215 215),
     BORDER-LEFT-COLOR=RGB(215 215 215),
     BORDER-RIGHT-COLOR=RGB(215 215 215),
$
TYPE=DATA,
     COLUMN=N2,
     FOCEXEC=IBFS:/WFC/Repository/SAP/DOLLAR_LIST/GM_per_Customer_by_Order.fex( \
     Bill_End_Date=&Bill_End_Date.QUOTEDSTRING \
     Bill_Start_Date=&Bill_Start_Date.QUOTEDSTRING \
     Domestic_International=&Domestic_International.QUOTEDSTRING \
     Intercompany_Std=&Intercompany_Std.QUOTEDSTRING \
     ISDISCOUNT=&ISDISCOUNT.QUOTEDSTRING \
     Sales_Document_Description=&Sales_Document_Description.QUOTEDSTRING \
     Sold_To_Party_Name=N2 \
     ),
          TARGET='_blank',
$
TYPE=TABHEADING,
     COLOR=RGB(75 75 75),
     STYLE=BOLD,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='HELVETICA',
     SIZE=24,
$
TYPE=TABHEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD+ITALIC,
$
TYPE=HEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='HELVETICA',
     SIZE=24,
     STYLE=NORMAL,
$
TYPE=SUBTOTAL,
     BORDER-LEFT=LIGHT,
     BORDER-LEFT-COLOR='BLACK',
$
TYPE=GRANDTOTAL,
     BORDER-TOP=OFF,
     BORDER-LEFT=LIGHT,
     BORDER-TOP-COLOR=RGB(102 102 102),
     BORDER-LEFT-COLOR='BLACK',
$
ENDSTYLE
END



Greg Coley
September 03, 2019, 08:34 AM
BabakNYC
What happens if you expand all the way to Division? I think the drill is only available at the lowest BY field.


WebFOCUS 8206, Unix, Windows