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.

 All Forums
 Development Tools
 Reporting Services Development
 Convert varchar to int

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)) or
CInt(Sum(Fileds!NAMEOFFIELD.Value))
Go to Top of Page
   

- Advertisement -