Hi Experts,
I'm building a report in Visual Studio (an rdl file) and my dataset is coming from a stored procedure.
I am putting the dataset into a table.
I would like to put the dataset into only one table, because it exports to Excel better that way and my users will be doing a lot of that.
So my question is about groups within the table. How do I create a group so that based on one column's value that data will appear with a green background and the others in white, etc.
ColA | ColB | ColC
datarow1
datarow2
datarow3
etc.
So if a value in datarow1 is equal to 0, then I want that entire row to go green. Otherwise stay white.
I thought I could do this by creating groups within the table and creating a filter then manually colouring that group green, but can't seem to make it work.
Please help?
Thank you,
rss2
Start Free Trial
