Add alternating row color to SQL Server Reporting services report

by

Go to the table row’s BackgroundColor property and choose “Expression…”

Use this expression: 

= IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

This trick can be applied to many areas of the report.

And in .NET 3.5+ You could use:

= If(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

Not looking for rep–I just researched this question myself and thought I’d share.

More Related Contents:

  1. hide/remove header and footer
  2. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  3. SSRS 2014 report deploy issue
  4. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  5. Format SQL in SQL Server Management Studio
  6. SSRS report definition is newer than Server
  7. Need help in calculation using two Datasets using Expression SSRS
  8. Local and global temporary tables in SQL Server
  9. Get first day of week in SQL Server
  10. What is the significance of 1/1/1753 in SQL Server?
  11. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  12. SQL Server add auto increment primary key to existing table
  13. Insert Update trigger how to determine if insert or update
  14. SQL Server: UPDATE a table by using ORDER BY
  15. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  16. Do I really need to use “SET XACT_ABORT ON”?
  17. SQL Server: How to select all days in a date range even if no data exists for some days
  18. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  19. How do you create a yes/no boolean field in SQL server?
  20. Using COALESCE function to make values separated with commas
  21. How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
  22. Assign result of dynamic sql to variable
  23. How do I create a multiple-table check constraint?
  24. Stored Procedure and Permissions – Is EXECUTE enough?
  25. Best way to store time (hh:mm) in a database
  26. Stored procedure – return identity as output parameter or scalar
  27. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  28. SELECT INTO a table variable in T-SQL
  29. SQL Server: Filter output of sp_who2
  30. How can I insert binary file data into a binary SQL field using a simple insert statement?

Leave a Comment