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.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…