I need to access the NormDist function within Excel from a Reporting Services Report. I've added the reference to the Excel object, created Public Function in the code window that creates the Excel.Application object and calls the NormDist function and returns the result to the report. When we run the report from our development machine, the function returns correctly. However, when, after we deploy the report to our report server, and run the report, that column simply displays ERROR with no other explanation...
Any idea on why on the report server this would not work? Excel is installed on the server.
Any help at all would be most appreciated!!!