October 2007 Entries

Leading Spaces in SQL Reporting Services

SQL Reporting Services has a really annoying "feature" that essentially removes all leading spaces from a field, when rendering a report to the ReportViewer control. You cannot use  , You cannot use space(5), etc. But, if you need to do leading spaces, you can set a formula in the padding field of the cell. Fantastic