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 |
|
andersonb
Starting Member
5 Posts |
 Posted - 2012-09-07 : 16:24:18
|
| I need to convert a nvarchar (30) to a number so that it will SUM in Report Builder 2.0. Can you help? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-08 : 07:35:00
|
You can use an expression either in the SUM or in the data column itself - something like this:=SUM(CDbl(Fields!YourCharColumn.Value)) I don't have report builder 2.0, I am guessing based on 3.0, but I don't think this part has changed much. |
 |
|
|
andersonb
Starting Member
5 Posts |
Posted - 2012-09-10 : 07:46:15
|
| [quote][i]will give that a try. Thanks! |
|
|
|
|
|
|
Trying to Convert a nvarchar (30) to a number