Expression to add alternating row color for rows in a SQL Report

Go to the table row's BackgroundColor property
Then click on the down arrow and choose "Expression..."
Enter the below code in that expression value.

= IIf(RowNumber(Nothing) Mod 2 = 0, "LightBlue", "White")

It sets the alternating row values as LightBlue and White.

No comments:

Post a Comment

Unable to load the data model for your power bi report...

There was a Power BI report which was working fine and suddenly it throws the below error "Unable to load the data model for your Pow...