 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| SET TARGET=_blank PROBLEM | Login/Join |
| Gold member |
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'), $ | ||
|
| Expert |
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
| |||||||||
|
| Gold member |
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 | |||
|
| Gold member |
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 | |||
|
| Gold member |
Hey, Follow up. After looking through some more help files. Using TARGET=_blank can't be used with DrillMenus. Thanks for the help | |||
|
| Platinum Member |
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 Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Databases: Oracle 10g, SQL Server 2000, DB2. | |||
|
| Gold member |
Sorry, forgot to mention with PDF reports. I don't recall where I was just searching through help on IBI web site. | |||
|
| Platinum Member |
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 Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Databases: Oracle 10g, SQL Server 2000, DB2. | |||
|
| Gold member |
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? | |||
|
| Platinum Member |
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 Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Databases: Oracle 10g, SQL Server 2000, DB2. | |||
|
| Gold member |
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. | |||
|
| Gold member |
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, $ | |||
|
| Platinum Member |
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 Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE Databases: Oracle 10g, SQL Server 2000, DB2. | |||
|
| Virtuoso |
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. Thanks! Mickey
| |||||
|
| Gold member |
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, $ | |||
|
| Virtuoso |
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
| |||||
|
| Gold member |
Thanks Mickey. I will just wait for our upgrade then modify the report to look like I wanted it. Again thanks. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |