I have an MRE report (in PDF) that I want to have drill down to a .fex in my self-serve environment.

I added this to the stylesheet of the MRE report
TYPE=DATA,
COLUMN=CURR_OPEN_ORDERS,
TARGET='_blank',
FOCEXEC=cp_opentickets(CUST_NUM=CUST_NUMBER PL_NUM=IDER),$

and I get an error
ERROR: ERROR_MR_FEX_NOT_FOUND Can't create item object based on provided item key cp_opentickets.

The fex name is right, and we use this same technique on other reports.

Ideas?

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

Prior to 7.6 this would have worked. Post 7.6, the URL is created with the assumption that the fex is actually a MRE based fex. As a quick way to resolve this, create a fex in MRE with the same name that does a -MRNOEDIT -INCLUDE fexname. A more long term option might be to create a generic MRE fex that you can drill do that will include a parameter based fex name using the same technique.

Example:

TYPE=DATA,
COLUMN=CURR_OPEN_ORDERS,
TARGET='_blank',
FOCEXEC=app/drilldown(INCFEX='cp_opentickets' CUST_NUM=CUST_NUMBER PL_NUM=IDER),$  

MRE Fex (drilldown.fex)

-MRNOEDIT -INCLUDE &INCFEX

That's an interesting idea, dhagen, but it's a little beyond my skill level I think.

We really just need this PDF to drill down into a self-serve fex, whether they bring up the PDF in MRE or it shows up as an email attachment, it would be nice if drill downs worked from either situation.

Thanks for the tip dhagen, but I need this to work outside of MRE. It's a great idea though!

This has been addressed several times on the forum. There is a Tech Memo mentioned in this thread that should address your issue.

Oops! Even better - there's a whole section in Chapter 2 of the MR Developer manual on this exact topic.

It took me a minute, but I looked at how we were able to do this with another report. I'm sorry to have wasted all of your time looking for this answer when it was right in front of me.

I can call a self-serve fex from an MRE fex by adding this to the top of the MRE Fex...

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

Then, just do the drilldown in stylesheet like usual...
TYPE=DATA,
COLUMN=CURR_OPEN_ORDERS,
TARGET='_blank',
FOCEXEC=cp_opentickets(CUST_NUM=CUST_NUMBER PL_NUM=IDER),$

Hope this helps someone.

Boy it sure did help! I owe you a beer bud.

For those that follow you can even tighten it more:

  SET FOCEXURL = /ibi_apps/WFServlet 

That automatically resolves to whatever webserver the focexec is running on. No need to explicitly specify the server name.

J.