.netsql-serverreporting-servicesssrs-2008bids
SSRS BIDS 2008 Alternating Background Colours when Grouped by
Can anyone help with an expression to alternate the colors between records under 'Service'. The report is GROUPED BY 'Service'.
I have tried =IIF(RowNumber(Nothing) Mod 2, "Silver", "White") previously however I think the GROUP BY is causing an issue here and cannot find a clear solution.
Solution
Use:
=IIF(RunningValue(Fields!Service.Value,COUNTDISTINCT,NOTHING) MOD 2 = 0, "Green","Red")
Set this expression in that box in your SS and you should be fine.
If you want to go even more in-depth and get crazy with your coloring, check out this blog post on advanced grouping and coloring.
- Does the .net framework have a build-in method to convert from degrees to radians?
- Why .NET Core introduced Autofac since it has dependency control system?
- How do I check if a filename matches some wildcard pattern?
- Token Request Failing and Returning error invalid grant
- Bug in .NET MAUI Custom ScrollView for iOS
- IIS server error .Server Error in '/' Application
- How to iterate over ReadOnlySpan in F#?
- Shared AssemblyInfo for uniform versioning across the solution
- Adding classes to Blazor(Razor) Validation
- Correct way to link lssl and lcrypto for a static lib
- dotnet publish --self-contained -> running the app still asks for .net installation
- DataTable already belongs to another DataSet
- Read connection string from web.config
- Split String into smaller Strings by length variable
- Autofac Access the IoC container in .NET MAUI
- .NET difference in DateTIme parsing
- How to make Entity Framework Data Context Readonly
- Prevent multiple instances of a given app in .NET?
- compiling C code and C# code both into .NET DLL
- How to manage multiple uses of a model in an application?
- How to enlist with a TransactionScope?
- Disable bootstrap offcanvas closure on backdrop click in Blazor .NET app
- Detect if headphones are plugged in or not via C#
- The named 'CommandType' does not exist in the current context
- Launching an application (.EXE) from C#?
- internal vs public in C#
- PowerShell script to return versions of .NET Framework on a machine?
- string interning vs address in memory
- Parallel Tasks - Run Parallel threads but dont wait for other Tasks to complete and get the latest data from database
- Custom NuGet feed with invalid certificate