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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-12-21 : 16:05:42
|
| Guys -Is is possible to format the data as percentage (Ex. 19,99) prior to export to the spreadsheet ?The last line on the spreasheet is a percentage, on the current procedure, after the report runs, someone needs to open the spreadsheet and format the last line as a percentage, I was wondering if that could be done all programaticaly.Thanks in advance.---Thanks!Igor. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-21 : 16:27:48
|
| Does ur percentage value should be delimitted by comma ?ie. is it 19,99 or is it a printing mistake ? (should be 19.99)Can't u get the percentage by multiplying the corresponding value by 100?Ex : Select a,b,c, c * 100.00 from tbl |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-12-21 : 16:56:18
|
| It was a print mistake on my part, I'll give that a shot. Currently I have the calculation to do divide an amount by the total, and I'll try multiplying that by 100...---Thanks!Igor. |
|
|
|
|
|
|
Is that possible to format my data prior to export