Hi All

We have a report that was working (Drill from Excel report) but now it is not working when you drill from the Excel Report. It gives ..fex (drill Fex) RunItem Access Denied error
I checked the security on this Fex, it is there.. I can run it by itself... Just when drilling from the main excel report it gives this error
here is the drill code

TYPE=DATA,
     COLUMN=N11,
     FOCEXEC=IBFS:/WFC/Repository/lawsonwf/std_reports/reportsfqcp5/pr_empannualsalary_by_distribution_drill.fex( \
     EmpNo=N11 \
     Job=N10 \
     ReportName='EMPANNUALSAL_BYDIST_BYPROC_DETAIL' \
     BeginDate=&RANGE_BEG_DATE.QUOTEDSTRING \
     EndDate=&RANGE_END_DATE.QUOTEDSTRING \
     REPORT_AUTO_NO=&HOLD_RAN.QUOTEDSTRING \
     ),
	 ALT='CLICK TO DRILL (N10)',
$  

if you had similar situation, would appreciate if you can share solution .. I opened the case with IBI, so far no solution that would get red of this error... about two weeks ago it was working , now getting this error..

This message has been edited. Last edited by: FP Mod Chuck,

Can you think of any changes on the Reporting Server or Client? Usually, code that used to work doesn't stop working unless something has changed. Are there other examples doing similar things that work or have all drill downs stopped working?

Would the drill down work if you switched from Excel to HTML or PDF?

Can you create whole new simple test report that does a drill down from Excel?

Thank you BabaNYC

I figured out.. It has to do with Browser settings.. Somehow my browser settings were changed .. I did the following to resolve the issue.. in case someone else has the same issue

To address this issue for the user:
1. Access IE.
2. Click on "Tools", "Internet Options" and "Advanced".
3 Reset the Internet Explorer settings.

This will set the browser back to the original IE settings.

Now I get the excel warning message about opening the excel file after you click on the drill

Thanks

I did the above and it worked few times.. But now I am back to the same problem. Access Denied error comes again... Our drills from PDF/HTML files work , just from Excel Report Drill to another excel Report gives this error... I have called IBI tech support and no response so far.. So if anyone out here had the same issue and how they resolved it, please let me know

Thanks