TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Kavitha M
NA
21
6.5k
Get Sum - From Thousand seperated values SSRS
Apr 28 2015 1:49 AM
Hi ,
I have report in ssrs. I have fields which mention last year sales,this year sales in dollers as well as in percentage. Now I get the record from SP as thousand seperated values like following :
REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,ROUND(sum(A.TY_SalesDollars),0)),1), '.00','')as TY_Sales,
REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,ROUND(sum(A.LY_SalesDollars),0)),1), '.00','')as LY_Sales
I get values in fields with thousand seperator. Now I want to get SUM of this column in SSRS. When i use
SUM(Fields!TY_Sales.Value) I got below error in Total field -- > '#Error'
Can anyone give me idea to resolve this? Thanks in advance
Reply
Answers (
3
)
Reoprts in Asp.net with Report Viewer
How to Use Barcode in rdl report