Tag: SSRS

  • 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 […]

  • 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 […]