I used to be able to create a fex with excel drill down to another excel drilldown just be having

TYPE=DATA,
COLUMN=N2,
FOCEXEC=app/drillrpt,
in the style sheet.

That is not working anymore for some reason (yet it does on some older fex created prior to today)
I got it to work by added the following code:


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


TYPE=DATA,
COLUMN=N2,
FOCEXEC=app/drillrpt.fex(IBIF_webapp='/ibi_apps' IBIC_server='EDASERVE' IBIWF_msgviewer='OFF' IBIAPP_app='fad_irf_target' IBIMR_drill='X,fadomain/fadomain.htm' IBIMR_random=RAND),

But I don't know why this started happening - I don't want to do it this way.

I found out that the hyperlink was not being created but a filelink was

file:///c:\ibi_apps/WFServlet%3fIBIF_webapp=\ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,fadomain/fadomain.htm&IBIF_ex=app\j2&CLICKED_ON=&

the hyperlink used to start with http://SERVER

Any clues what happened? (I'm on version 7.63)

What version of excel?

jammer -
I ran into the exact same issue a few months back. A mouse-over the drilldown link was displaying something like C:\.... and not the (servername\...) needed for drilldown.

The culprit turned out to be another Excel related product that was just installed. In my case it was the "SAS add-on for MS-Excel". It is a quick tool to let users get to SAS from within an excel spreadsheet, by adding a SAS option on the GUI menu across the top. Uninstalling this product restored my drill-down links.

Did you have any such s/w installed on your PC recently ? In some places, the network admins actually "push" some s/w to PCs without the user knowing about. Check it out.

Hope that helps.
Sandeep Mamidenna

EXCEL 2003

Sandeep

Not that I know of but it is a development server so anything is possible.

We did create a new dev server which we set up to access dev studio on the network - not sure if that could have done something.

How did you fix things?

Jammer,

Is the spreadsheet opening in the browser or in Excel?

I've seen this behaviour when the spreadsheet has opened in Excel application itself rather than the browser add-in or when the spreadsheet has been saved and reopened.

Regards

Stuart

Stuart,

I think you are onto something.

On one server I get the filelink (file///) the other a hyperlink (http://) Both open in excel 2003.

I do notice the server where it works the name of spreadsheet is WFServlet ,but the server that is not working has a random name xbwjj[1].xht

Does this have something to do with redirection? Do you you know what is causing this?

Thanks
John