=Switch(Fields!Orders.Value < 100,"Red", Fields!Orders.Value > 100, "Green")
The above statement is an example on how to use the ‘Switch’ statement in SQL Server Reporting Services. This example checks the ‘Orders’ value in a row and if the value is less than 100, displays “Red”. If the value is greater than 100, then display “Green”
I ran into an issue the other day while importing data from an Excel file into SQL Server 2005. I had columns that contained fields that have more than 255 characters. When running the import, SSIS failed because it kept truncating the fields which caused the task to fail. It fails because the Microsoft Excel ODBC driver will, by default, scan the first 8 rows of your data to determine the type of data in each column. To fix this, you need to go into the registry and modify the ‘TypeGuessRows’ to scan more than 8 rows. The key can be found in the following:
