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 |
|
giszzmo
Starting Member
29 Posts |
 Posted - 2015-01-30 : 14:29:33
|
Hi, I have some numbers that came in as a varchar but I need to convert them to an int in an SSRS expression. I've tried many expressions but none seem to work. If anyone could point me in the right direction. Thanks! Here is what I have that doesn't work:=cstr(cint(Fields!Grades.Value as INT)-1) |
|
|
ladyrichardson81
Starting Member
2 Posts |
Posted - 2015-02-04 : 17:10:21
|
| Have you tried (cast(Field as INT)) orCInt(Sum(Fileds!NAMEOFFIELD.Value)) |
 |
|
|
|
|
|
Convert varchar to int