title: SSRS Alternating row color issues when some rows are not visible
body: <p>I have a report where I have a customerID group, and no detail group.  The dataset that I have going to the report will have each customer, as well as numerous columns of information for that customer.  I have created a bunch of rows, that are labeled appropriately, and displays valid data associated with it (ex. <strong>Age:</strong> 34, <strong>Sex:</strong> Male).  I also have some rows where the data coming back may be blank or NULL.  These rows I choose to hide the visibility for.  I am unsure how to handle the alternating background color, because there's always going to be some rows that are not visible, but you can't predict which ones they will be.  If I had the data unpivoted in the dataset, I could just eliminate the rows that would not be visible, and just display the rows with a detail grouping and do the RowNumber Mod solution.  I was hoping there's an easy way to do this the way that I currently have it set up though.  Is there a way to check the background color of the previous visible row? Set a report variable to the color of what the next visible row should be?</p>