将交替行颜色添加到SQL Server报告服务报告 [英] Add alternating row color to SQL Server Reporting services report
问题描述
如何在SQL Server Reporting Services报告中遮蔽交替行?
编辑:有很多好的答案在下面列出 - 从快速和简单来复杂而全面的。唉,我只能选择一个...
转到表行的BackgroundColor属性并选择Expression ...
使用以下表达式:
$ $ $ $ $ $ $ $ $ $ $ Mod 2 = 0,Silver,Transparent)
这个技巧可以应用到很多领域。
在.NET 3.5+中你可以使用:
pre $ $ c
$ b $ p>不寻找代表 - 我刚刚自己研究这个问题,并认为我会分享。
How do you shade alternating rows in a SQL Server Reporting Services report?
Edit: There are a bunch of good answers listed below--from quick and simple to complex and comprehensive. Alas, I can choose only one...
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.
这篇关于将交替行颜色添加到SQL Server报告服务报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!