Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tjwent69
Starting Member
30 Posts |
 Posted - 2008-02-12 : 16:28:06
|
| Is there a property or a format type that I can use on a field to enter an excel formula and have it actually be a formula once it is saved to excel out of reporting services. This is a 'what if' report. That the users want to fiddle with after it is generated.I have item number, cost, sell price, and discount from the database. I calculate the gross profit and the percent from those fields. They want to take this report, save it to excel and then have the gross profit change when they enter a new discount amount. I have tried to just enter the fields like they would look in excel but the report just shows A3 - A2. If I use the = before it will not run and says A3 is not defined. I have tried quotes, parenthesis, square brackets any thing that looked remotely possible in properties menu to have the values save as a formula. I don't think it is possible but would like a second opinion. |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-02-20 : 16:30:33
|
| No it is not possible. You have to include fomulas to the excel sheet |
 |
|
|
|
|
|
Saving a report to excel and populating formula's