Hi folks,

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,

Martin

Which version are you running this with?

Using 8201M

Martin

Can you please post the drill down fex as well

Thanks

It's the same fex, it is calling itself.
Sorry, I forget to mentioned.

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


It appears that it don't with 8201M client gen 193 and RS gen 1107

Martin

This sounds like a bug in that gen then. You should report it to techsupport...

Thanks for your help Chuck.

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

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.

"with various bits dynamically commented out" - us coders are rapidly being left out of the Information Builders Universe.

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.

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...