SSSRS Number Stored As Text

SQL Server,
Sharing is Caring

Today, while changing a report in SQL Server Reporting Services I noticed that my report when exported to excel was showing the dreaded “Number stored as text.”

When a value was 0, I was replacing with a blank string. By changing it to return Nothing. I was able to get rid of the dreaded Number Stored as Text message.

Hope this helps!

Sharing is Caring

Related Posts:

Brian is a software architect and technology leader living in Niagara Falls with 13+ years of development experience. He is passionate about automation, business process re-engineering, and building a better tomorrow.

Brian is a proud father of four: two boys, and two girls and has been happily married to Crystal for more than ten years. From time to time, Brian may post about his faith, his family, and definitely about technology.