I am trying to create a multi item drill on a text field in a chart. I am able to create a single drill with no tag/label/alternative text on the Text. Is there an issue with this in 8201?

TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=9, COLOR=RGB(109 110 113), STYLE=NORMAL,
DRILLMENUITEM='Detail',
FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_detail_xls.fex( \
FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING \
TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING \
FLD='_FOC_NULL' \
DATE='_FOC_NULL' \
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING \
WFRPT='All Rxs' \
POLICYNAME= 'FOC_NONE' \
DRUGNAME= 'FOC_NONE' \
DRCLASS= 'FOC_NONE' \
), TARGET=_blank,
DRILLMENUITEM='GPI4',
FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_gpi4_rpt.fex( \
FLD='_FOC_NULL' \
DATE='_FOC_NULL' \
FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING \
TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING \
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING \
WFRPT='All RxS' \
), TARGET=_blank,
DRILLMENUITEM='Top Drugs',
FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_drugname_rpt.fex( \
GPI4='_FOC_NULL' \
FLD='_FOC_NULL' \
DATE='_FOC_NULL' \
FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING \
TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING \
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING \
WFRPT='All Rxs' \
), TARGET=_blank,
$

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

Do you get an error or does it not pass the variables?

It is broken,it does not do anything. Once I removed two of them it works for the remanding 1 drilldown.

There are a couple of entries that mention something about EMBEDHEADING. http://forums.informationbuild...1057331/m/6957001096

Can you try SET EMBEDHEADING = OFF and see if that makes a difference?

Using DRILLMENUITEM you need to have all your parameters on the same line where the FOCEXEC is

FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_detail_xls.fex( FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING FLD='_FOC_NULL' DATE='_FOC_NULL' 
 GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING WFRPT='All Rxs' POLICYNAME= 'FOC_NONE' DRUGNAME= 'FOC_NONE' DRCLASS= 'FOC_NONE' ), TARGET=_blank,

Seems that using \ as concatenation char is not anymore working in 8.2. for DRILLMENUITEM
I have been told by IB that this is not a bug, this is what the default style sheet produces now.

Thanks Martin but that does not work. I am currently using WF 8.2.01.

And having all on the same line such as

DRILLMENUITEM='Detail', FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_detail_xls.fex( FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING FLD='_FOC_NULL' DATE='_FOC_NULL' 
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING WFRPT='All Rxs' POLICYNAME= 'FOC_NONE' DRUGNAME= 'FOC_NONE' DRCLASS= 'FOC_NONE' ), TARGET=_blank,

Please share your code

I created the following with AppStudio:

  
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.BODY.BODYTYPE
HEADING
"Drill"
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 = warm,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     DRILLMENUITEM='ds1',
          FOCEXEC=focalpoint/ds1( \
     MSORT='CAR' \
     ),
          TARGET='_blank',
     DRILLMENUITEM='ds2',
          FOCEXEC=focalpoint/ds2( \
     CSORT='SEATS' \
     ),
          TARGET='_blank',
$
ENDSTYLE
END

ds1:

  
TABLE FILE CAR
SUM SALES
BY &MSORT
END

ds2:

  
TABLE FILE CAR
SUM SALES
BY COUNTRY
ACROSS &CSORT
END

As you can see, no problem with \

This is for TABLE FILE. The requirement is GRAPH FILE.

Works just as well with GRAPH.

Still is not working in 8.2.01. As a work around I one line with each drill as a separate Text in the heading. I will be opening a case with IB for this issue.

Thanks for the help.