I have the following code in my project. My problem is it works fine has long as the SET TARGET=_blank is not in the code. Once I place the set command in my code the drill down no longer works. Any Ideas?

$
-*Run Awarded Info Drill Down for GIS
TYPE=FOOTING,
LINE=1,
ITEM=1,
OBJECT=TEXT,
FONT='ARIAL',
SIZE=9,
COLOR=BLUE,
DRILLMENUITEM='HTML',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'HTML'),
DRILLMENUITEM='PDF',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'PDF'),
$

Mike,

You do not say how you are applying the target, but bear in mind the target will not work with PDF.

This should work OK.

-*Run Awarded Info Drill Down for GIS
TYPE=FOOTING,
LINE=1,
ITEM=1,
OBJECT=TEXT,
FONT='ARIAL',
SIZE=9,
COLOR=BLUE,
DRILLMENUITEM='HTML',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'HTML'), TARGET=_blank,
DRILLMENUITEM='PDF',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'PDF'),

T

Tony,
I tried your code but get the error unknown word @ line ### TARGET.

I have the SET TARGET=_blank at the top of my code.

I have several drill downs some without the drillmenus. The ones without are compound reports that will only display correctly in PDF. I need them open in a new window. can this be done?

With SET TARGET=_blank at the top the drill down that runs the compound pdf report opens in it's own window but the drillmenu drill downs what work. Thanks

Well, after looking through a lot of help files. It looks like what I need can't be done.

Thanks Tony for your help. adding TARGET=_blank after the FOCEXE code using DRILLMENU will not work. If I remove the DRILLMENU it excepts the TARGET=_blank. I think this is bug, but not sure.

Later

Hey, Follow up.

After looking through some more help files. Using TARGET=_blank can't be used with DrillMenus. Thanks for the help

Interesting you'd say that. I have drillmenuitems in a dashboard report with TARGET=_blank and it works just fine.

Where did you find this obviously very helpful help file?

Ken
WF 5.3.3

Sorry, forgot to mention with PDF reports. I don't recall where I was just searching through help on IBI web site.

Mike, bear with me. I still haven't seen the bottom of my first cup of joe yet this morning.

One of two things could be going on here. The first is that your report with the DRILLMENUITEMs is in PDF format. If this is the case, then drill menu shouldn't work anyway, regardless of whether you're using TARGET=_blank or not.

If this isn't the case (as I might suspect because of your earlier posting).

TYPE=FOOTING,
LINE=1,
ITEM=1,
OBJECT=TEXT,
FONT='ARIAL',
SIZE=9,
COLOR=BLUE,
DRILLMENUITEM='HTML',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'HTML'), TARGET=_blank,
DRILLMENUITEM='PDF',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'PDF'),

then, the TARGET=_blank shouldn't do anything for the PDF output format since PDF will open a new window anyway. I tried a report in HTML output format with drillmenu's and PDF outputs, including the TARGET=_blank and it had no adverse effect at all.

Ken

You're correct, the first report is HTML which drills down to PDF (If drillmenu = pdf), but does not open in a new window. I remember seeing in the help files on the IBI wed site that TARGET=_blank will not work with PDF reports. Maybe I'm missing something. Would it help if I posted the entire code for the report?

What version are you running? I am on 5.3.3 and the following directs the drilldown to a new window:

TYPE=DATA,
COLUMN=DRILL_COLUMN,
DRILLMENUITEM='PDF',
FOCEXEC=newrpt(OUTPUT = 'PDF'),
TARGET=_blank,
DRILLMENUITEM='HTML',
FOCEXEC=newrpt(OUTPUT = 'HTML'),
TARGET=_blank,
$

Ken

I'm currently running version 5.2.7

We are in the process of upgrading to version 7. but this want happpen for another six months.

I will give the code you just sent a try. It will be a few days. My boss as me working on something else right now. Thanks for all your help. I will post the results soon.

I tried the code K.Lane sugguested. I'm still geting the following error.

FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE: 31 TARGET

perhaps this is not supported in version 5.2.7

TYPE=FOOTING,
LINE=1,
ITEM=1,
OBJECT=TEXT,
FONT='ARIAL',
SIZE=9,
COLOR=BLUE,
DRILLMENUITEM='HTML',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'HTML'),
TARGET=_blank,
DRILLMENUITEM='PDF',
FOCEXEC=app/b3gawpby.fex(CONTRACT=CONTRACT_ID OUTPUT = 'PDF'),
TARGET=_blank,
$

Mike,

This might be the problem. I can't say for sure since I haven't used 5.2.7 in quite some time now.

I copied your drilldown code directly into my report and it worked, as follows:

TABLE FILE CAR
SUM SALES BY COUNTRY BY CAR
FOOTING
"TEST"
ON TABLE SET STYLE *
TYPE=FOOTING,
LINE=1,
ITEM=1,
OBJECT=TEXT,
FONT='ARIAL',
SIZE=9,
COLOR=BLUE,
DRILLMENUITEM='HTML',
FOCEXEC=a2(CONTRACT=CONTRACT_ID OUTPUT = 'HTML'),
TARGET=_blank,
DRILLMENUITEM='PDF',
FOCEXEC=a2(CONTRACT=CONTRACT_ID OUTPUT = 'PDF'),
TARGET=_blank,
$
ENDSTYLE
END

The only difference between this and yours is that the focexec name has changed from app/b3gawpby.fex to a2. I never use the app/ or the .fex extension. Try removing that. Stranger this have happened. Any of use using WebFOCUS know there are far too many undocumented features within the language.

Ken

Ken has a good point about the ".fex" needing to be removed. I also would suggest using the SET TARGETFRAME=_BLANK before the TABLE FILE statement and then remove the TARGET= from each DRILLMENUITEM statement. The WF 71 manual does not indicate that TARGET= can be used with DRILLMENUITEM. However, based on Ken's testing, it looks like it works. Go figure.

The last suggestion I have is to make sure _BLANK is in ALL CAPS. This is just a guess.

I've tried both Ken's and Mickeky's ideas. I still get the same error with Ken's suggustion and the report runs with SET TARGETFRAME=_BLANK before the TABLE FILE but when I click on the drill down I get Page can't be displayed in a new window. I have asked my support team to open a case file. I will post there response when i get it. I will put this on the back burner for now. Maybe while working on some other report I'll run across the solution. Thanks for your help.

P.S. this is how the code looks now.

$
-*Run Awarded Info Drill Down for GIS
TYPE=FOOTING,
LINE=1,
ITEM=1,
OBJECT=TEXT,
FONT='ARIAL',
SIZE=9,
COLOR=BLUE,
DRILLMENUITEM='HTML',
FOCEXEC=b3gawpby(CONTRACT=CONTRACT_ID OUTPUT = 'HTML'),
TARGET=_blank,
DRILLMENUITEM='PDF',
FOCEXEC=b3gawpby(CONTRACT=CONTRACT_ID OUTPUT = 'PDF'),
TARGET=_blank,
$

Mike,

Two things:

1) I get the same "page cannot be displayed" problem when using the SET TARGETFRAME=_BLANK so do not use that suggestion. This happens in WF 711.

2) I tested the code from Ken with WF 523 and I got the "(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE: 10 TARGET" error message. However, this runs fine with WF 711.

This probably is not a feature with the WF 52x releases as you already suspect.

This message has been edited. Last edited by: mgrackin,

Thanks Mickey. I will just wait for our upgrade then modify the report to look like I wanted it. Again thanks.