call excel function - xIRR from the report

[igor22]

Hi,
I need to call an excell function, xIRR, from my report.
How can I do that?

Thanks,

Igor

 

[xlbo]

If the report is in Reporting Services (which this forum is for), then I don't think you can

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[igor22]

Geoff,
yes, my report is in Reporting Services but I can make it client-side if needed. How would I be able to use excel functions then?

thanks,
Igor

 

[nomadicalloy]

You can use officewriter

http://officewriter.softartisans.com/officewriter-8.aspx

You can use your rdl file in excel to create complex excel functions. Only problem with this tool is, it doesn't support multi select and cascading parameter.

http://www.xpherion.com/