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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-10-28 : 08:07:39
|
| Hi,Im getting quite annoyed with the relationship between SSRS and Excel.I have a matrix with values and the data type is int, when exporting the report in excel the client likes to play with the numbers for their own sanity check. But cant SUM or ADD the numbers together keeps staying at '0' as result. I have to manually convert the values in the cells to number in excel which is annoying. How can this be avoided? Thanks |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-28 : 08:37:42
|
| If it was for internal use I would tell the users they need to do the reformat within excel. But since you chose to use that magic word "Client" I guess that would not be appropriate...JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-10-28 : 08:41:41
|
I sent you an email johnquote:
Originally posted by JCirocco
If it was for internal use I would tell the users they need to do the reformat within excel. But since you chose to use that magic word "Client" I guess that would not be appropriate...JohnIt's a small world (but I wouldn't want to paint it)
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-28 : 13:01:33
|
| They gave me one more week so I will look at it when I get home (assuming you sent to the gmail)JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-10-28 : 17:01:12
|
quote:
Originally posted by cipriani1984
Hi,Im getting quite annoyed with the relationship between SSRS and Excel.I have a matrix with values and the data type is int, when exporting the report in excel the client likes to play with the numbers for their own sanity check. But cant SUM or ADD the numbers together keeps staying at '0' as result. I have to manually convert the values in the cells to number in excel which is annoying. How can this be avoided? Thanks
are you multiplying the number in your report? or scaling etc? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-28 : 18:07:59
|
| Yes, I have had the same issue but it was never a lot of fields. We had one at my last place that stored either a count on the number of times someone contacted us OR their birth date. Apparently the developers felt it was easier to use an unused note field instead of adding a new field. Is there a chance you can create a view of the data converting the fields and then your SQL can treat it normally??? Just a thought.I will poke around more tonight but another thought is to export CSV? Unless there are commas in the data, CSV exports without quotes so numbers are numbers regardless of field type they were stored in.JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-10-30 : 09:26:23
|
No, im not multiplaying or anything just formatting the number in report desingner doing:formatnumber((FieldsName),0)so it can decimal place for thousands etcquote:
Originally posted by rohitkumar
quote:
Originally posted by cipriani1984
Hi,Im getting quite annoyed with the relationship between SSRS and Excel.I have a matrix with values and the data type is int, when exporting the report in excel the client likes to play with the numbers for their own sanity check. But cant SUM or ADD the numbers together keeps staying at '0' as result. I have to manually convert the values in the cells to number in excel which is annoying. How can this be avoided? Thanks
are you multiplying the number in your report? or scaling etc?
|
|
|
|
|
|
|
Annoyance with Excel