SSSRS Number Stored As Text

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!

Windows Server 2008 – SMTP Doesn’t Work on Restart

I have a few applications that use the Windows SMTP Server to send email or to send email from SQL Server Reporting Services and of course database error notification. Each time the server restarted or IIS crashed neither of which happens often, I would forget I needed to go into IIS6 and start the SMTP Server up again and the SSRS subscriptions would all fail to send their files.

On Windows Server 2008, Simple Mail Transfer is set to manual by default. We need to change it to automatic by doing the following steps:

  • Start -> Administrative Tools->Services
  • Change Simple Mail Transfer to be Automatic