Use Excel funtions in SSRS report

Question

Use Excel funtions in SSRS report

Elaine Shafer-401422

Old Hand

Points: 309
More actions
May 14, 2012 at 5:09 pm

#268868

Hello,
Is it possible to use the Primary Interop Assemblies for Office with an SSRS report? I'm trying to use Excel formulas in my report. Or would I use the SQL CLR to do that?
Thank you,
Elaine Shafer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

If you are outputting to Excel or .csv you should be able use formulas in the output. If you are trying to build the formulas into the report before export, most functions people use are already exposed in SSRS Expressions, those that are not can be created with embedded custom code.

Elaine Shafer-401422 Old Hand Points: 309 More actions · Answer 2

Thanks Daniel,

I would like to be able to use a calculation in a report textbox. The main problem I'm having right now is the Excel GROWTH formula. I've not found an explanation that gives the same result as the spreadsheet does. We're using five years of birth counts to project the 6th year birth rate. In the spreadsheet the formula is =GROWTH(C86:C90,,{6}). Seems simple enough to recreate, but CAGR formulas do not give the same result, neither does (CurrentValue - PreviousValue) / CurrentValue.

Regards,

Elaine

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

Does this help?

http://social.msdn.microsoft.com/Forums/zh/csharpgeneral/thread/7d71d0d0-39f3-4f17-bfa6-7a8cf2dcbf6b

Elaine Shafer-401422 Old Hand Points: 309 More actions · Answer 4

Thanks, I had not found that one. I did read this one as well:

http://support.microsoft.com/kb/828526

But I'm not knowing how to plug the rows and columns into the equation, and not understanding what the constants are. For that I would need math help 🙂

So...I was hoping I could call the Excel functions from the report or use the CLR to do that.

Regards,

Elaine