Hi all,

I have a WebFocus report that will give format output as Excel. I will then have a link in Excel to drilldown to next level (call a new report). My problem is whenever I click the drilldown link, it asks me to log in to MRE again although I still have the MRE window open. Does anyone have a solution for this or some work-around on this type of problem?

Thanks a lot,

Shane Tran

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

Please update your signature to include the version of WF and the platform you are on. Also, it would help to know what version of Excel you are running.

I would be curious to see if anyone here would have any comments on this issue

I just updated my signature. Thanks

Does this happen for every drilldown, or just the first one?

Hi Dhagen,

It happens whenever I try to drilldown, every single time.

Thanks,

Post your code from both programs (between

the < / > above) and designate which fex is the drill down.

This is the first fex code:

TABLE FILE CAR
PRINT
COUNTRY
CAR
ON TABLE SET STYLE *
TYPE=DATA,
COLUMN=N2,
FOCEXEC=app/drill.fex(CAR='TOYOTA'),
TARGET=blank,$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

You then will need to rename the fex name in the calling line. Here I use "drill" as an example.

Here is the second fex code:

TABLE FILE CAR
PRINT
CAR
MODEL
WHERE CAR EQ '&CAR'
ON TABLE SET STYLE *
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

After I run the first, I got the excel open with a link to second fex on second column. I then click one of the link, it immediately asks me to log on to the MRE again with my MRE window is still open.

Thanks,

This works in our system. What type of server are you on? Are the programs in a domain or a server procedure? Is this running thru dev studio? Is this a straight MRE setup or do you have custom features?

Hi Pat,

We use Unix(Solaris) for server. The 2 reports are in the same domain. It's NOT running thru dev studio. We're using MRE 7.1.6 env. No custom features. Thanks.

When you go to MRE to run the first procedure, do you have to log on?
If so, you'll have to log on every time when you have a drill down activated from some other product like excel or pdf. Point is, when you're in that other product, it has no notion of internal or external cookies of IE.
User data (ie username/password) is never stored on disk, it is stored in a memory resident cookie. This thing belongs to IE (or whatever browser you're using). It will not be passed on to a third party product, not even if this is a product that runs within IE.

Anyway, this is as I understand the process of authentication.

Hope this helps. ...

Hi GamP,

I don't need to logon when running the first report. I think what you said there completely makes sense for me since when we do the drilldowns, we run the reports from Excel, and not the MRE itself. I just hope we have some work-around to avoid the problem. Thanks.

Hi Shane,

Have you tried searching "FOCEXURL"?
https://forums.informationbuilders.com/eve/forums/a/tpc/...551070251#9551070251

Hope this helps.

Cheers,

Kerry

Hi Kerry,

Thanks for your help. I'll take a look at it.

Hi Kerry and all,

This is exactly what I am lokking for. I found the answer in the forum. By perform these below steps, instead of opening as a separate window, it uses the same IE window. Whenever I drilldown I don't need to re-login again. For those folks that have the same issue, here are the steps:

1. Access Windows Explorer.
2. From the Tools menu, click Folder Options.
3. Select the File Types tab.
4. Select the XLS extension and then click Advanced.
5. Select the Browse in same window check box and then click OK.
6. Click Close to exit the Folder Options window.

Again, thanks for all your helps Kerry.