Most of the time I can find answer in this forum or doc, but now I'm totally lost.
I have the below code built using AS to replicate my issue that is working well but when I activate the « DRILLMENUITEM='By Model', » line (which also has been added using AS) nothing is working. It seems that none of the parameters are passed when I use the drill so the exact same result is displayed.
Can someone help me on this ?
-* FEX : IBFS:/WFC/Repository/IT/RptAndDrill.fex
-DEFAULTH &CNTRY= _FOC_NULL;
-DEFAULTH &BY3 = _FOC_NULL;
TABLE FILE CAR
SUM SEATS
DEALER_COST
BY COUNTRY
BY CAR
BY &BY3
WHERE CAR.ORIGIN.COUNTRY EQ &CNTRY.(|FORMAT=A10).Country:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
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=COUNTRY,
-* DRILLMENUITEM='By Model',
FOCEXEC=IBFS:/WFC/Repository/IT/RptAndDrill.fex( \
CNTRY=COUNTRY BY3='MODEL' \
),
TARGET='_self',
$
ENDSTYLE
END
This message has been edited. Last edited by: MartinY,
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
November 22, 2017, 12:32 PM
FP Mod Chuck
Martin
Which version are you running this with?
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 22, 2017, 12:45 PM
MartinY
Using 8201M
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
November 22, 2017, 02:04 PM
FP Mod Chuck
Martin
Can you please post the drill down fex as well
Thanks
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 22, 2017, 02:36 PM
MartinY
It's the same fex, it is calling itself. Sorry, I forget to mentioned.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
November 22, 2017, 05:31 PM
FP Mod Chuck
Martin
It appears to work for me with gen 106 of client 8201M and gen 1060 of the reporting server. The results below are from drilling down on FRANCE.
COUNTRY CAR MODEL SEATS DEALER_COST FRANCE PEUGEOT 504 4 DOOR 5 4,631
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 23, 2017, 07:49 AM
MartinY
It appears that it don't with 8201M client gen 193 and RS gen 1107
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
November 27, 2017, 10:34 AM
FP Mod Chuck
Martin
This sounds like a bug in that gen then. You should report it to techsupport...
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 27, 2017, 03:32 PM
MartinY
Thanks for your help Chuck.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
December 08, 2017, 02:46 PM
MartinY
Here is the solution.
When using DRILLMENUITEM everything must be on the same line !!!!
-DEFAULTH &CNTRY= _FOC_NULL;
-DEFAULTH &BY3 = _FOC_NULL;
TABLE FILE CAR
SUM SEATS
DEALER_COST
BY COUNTRY
BY CAR
BY &BY3
WHERE CAR.ORIGIN.COUNTRY EQ &CNTRY.(|FORMAT=A10).Country:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
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=COUNTRY,
DRILLMENUITEM='By Model', FOCEXEC=IBFS:/WFC/Repository/IT/RptAndDrill.fex(CNTRY=COUNTRY BY3='MODEL'),
TARGET='_self',
$
ENDSTYLE
END
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
December 14, 2017, 03:55 PM
susannah
hmmm im in 77 and I have a zillion drillmenu items and not a single one is on the same line... they're all at least 3 or 4 lines, with various bits dynamically commented out. hmmm.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 14, 2017, 04:13 PM
Francis Mariani
"with various bits dynamically commented out" - us coders are rapidly being left out of the Information Builders Universe.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 15, 2017, 07:54 AM
MartinY
quote:
hmmm im in 77 and I have a zillion drillmenu items and not a single one is on the same line... they're all at least 3 or 4 lines, with various bits dynamically commented out. hmmm.
I wish you that it will be reverted to work the "old" way before you install WF8...
quote:
us coders are rapidly being left out of the Information Builders Universe.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
December 15, 2017, 10:56 AM
Wep5622
Everything on the same line? OMG!
That's going to be a major pain with many of our drilldowns that have a gazillion parameters. We do our best to stay under URL length limitations, but they are still often a lot...
Weird too that the line-continuation backslash is often no longer required in recent releases, although there are still some unexplainable cases where it doesn't work without them...
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :