Has anyone found a way to pass an Excel Formula using Reporting Services? I have a report that is being used to generate a spreadsheet. I need to have the generated spreadsheet contain a foumula in 2 of the resulting cells. It's okay for the report to show the text of the formula. Once the spreadsheet is generated, the user types values into one column of the spreadsheet (an empty cell that I include in the RS report). Then I want the formula to automatically calculate.
I haven't been successful in trying to get reporting Services to pass the formula. All I want is something like this formula result in the spreadsheet:
Then user types info into X1 and the formula would calculate.
I'm not sure if it's possible to pass an excel formula to have it render correctly.