Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EXPANDBYROW and Drillthrough
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] EXPANDBYROW and Drillthrough
 Login/Join
 
Member
posted
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
 
Posts: 11 | Location: Pittsburgh, PA | Registered: February 13, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1658 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 11 | Location: Pittsburgh, PA | Registered: February 13, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1658 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EXPANDBYROW and Drillthrough

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.