Someone on 7.6.x please ease my mind on this one. We are upgrading from 7.1.6 to 7.6.9 and I am running into an issue with drilldowns from PDF/Excel reports. I've gone through the posts, tech issues, etc. but i'm still banging my head on this one. In the 7.1.x version, I generate a report with a drilldown. The link looks like

http: //servername/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,budgetbm.budgetbm,htm&IBIF_ex=app/moed02.fex&CLICKED_ON=name/value...

When I run the same report in WF 769, the URL is VERY different:

http: //servername/ibi_apps/WFServlet?IBIF_ex=app/moed02.fex&CLICK_ON=name/value...

Seems like it's losing half the necessary information. The second url results in "procedure not found"

I have the FOCEXURL=http: //servername/ibi_apps/WFServlet? in the fex, but it doesn't seem to be working. Possible something I am missing in my client server configuration?

This message has been edited. Last edited by: Darin Lee,

Further notes - I am trying to drill from an MRE procedure to a second MRE procedure. If I do not include the SET FOCEXURL= in the procedure, then I get the entire properly formed URL, except that it begins with file: /// instead of http: //

Any ideas?

¿¿¿hmmm???

I've never seen an extension used in the focexec parm before, so you might try it without that...

IBIF_ex=app/moed02.fex
IBIF_ex=app/moed02

Darin,

You mentioned that you are running a report in 7.6.9 that was created in 7.1.6. What happens if you recreate the report from scratch in 7.6.9?

I just created a drill-down report from scratch in 7.6.9 and the URL to the second report looks like...

http: //servername:port/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,powersys/powersys.htm&IBIF_ex=app/car2&CLICKED_ON=&COUNTRY=ITALY

As you can see here the MRE Domain = powersys, the procedure being called = car2, and the variable being passed is &COUNTRY=ITALY

This looks to be configured the same way your 7.1.6 URL is. I didn't SET anything or add any code beyond what the GUI created.

Dan

After a few days of testing, here's what I found out. I am using a freshly-built PC to do all my testing (didn't want to mess something up with my DevStudio install). On that PC, the Acrobat Reader and Excel open in their own windows, instead of opening with the browser plug-in. For whatever reason, if they do not open in the browser, the http: // portion of the URL becomes file: ///. Don't know why - seems like if it can be opened two different ways that WF should work for both of those ways. That's an easy-enough work-around (at least for us) but seems like a bug to me. Everything works OK as long as everything opens in the browser using plug-in helper apps.

What's more, I found that simply adding the SET FOCEXURL=http: //servername/ibi_apps/WFServlet into the focexec causes should ONLY be used for drilling to server procedures because it causes all the MR information to be lost.

I am still pursuing a full resolution through tech support but there's an answer for now (kind of).

Darin,
I was wondering if you ever resolved this issue. I am working with a similar problem and was curious to know if this was ever "truelly" solved? I am trying to allow for a drilldown in excel to another fex. If the excel spreadsheet is saved the drilldowns don't seem to work. I have also noticed the different URL's being used depending on where the report is being ran from...sometimes it is http://ibi_apps and other times it is C:///. If the URL is of http:// then the links seem to be "savable" but if it is the C:/// then they DO NOT work. Any ideas?

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

I'm having the same issue with Excel and drilldowns too. It only happens in Excel - all other formats work fine. If someone has some any ideas, please pass them my way!

WebFocus 7.6.10

Normally when you create a drilldown using FOCEXEC the link is generated as a relative URL
which requires the PDF or Excel to open in the browser.

When opened directly in the application any incomplete URL is always rendered as either file:///
or if you have saved it as x::/// where x is the drive you saved it to.

SET FOCEXURL =http://host/ibi_apps/WFServlet

forces a full url for none MRE drilldowns so they will open correctly

For MRE there is no equivalent to FOCEXURL so the best option is actually create the drilldown as a URL drilldown

for example for a none MRE drilldown

FOCEXEC=app/drill2(COUNTRY=N1),$

would become

URL=http://localhost/ibi_apps/WFServlet?(\
IBIF_ex='drill2' MODEL=N3),$


For MRE using Dans example it would be

 
URL=http://servername:port/ibi_apps/WFServlet?(\
IBIF_webapp=/ibi_apps \
IBIC_server=EDASERVE \
IBIWF_msgviewer=OFF \
&|IBIMR_drill=X,powersys/powersys.htm \
IBIF_ex=app/car2 \
CLICKED_ON= \
COUNTRY=ITALY \
),$


note any global vars need coding as &| 

You can add in parameters you need based on the above example