I have a table that is connected to a dataset that will return 5 and only 5 items every time. The background color for each row needs to be different so the first item will be red, the second will be orange, the third purple etc.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
I ended up using a switch but the concept was the same
Jim Horn
Can you post your Switch code? Kinda curious.
And a screen shot of your report with all the colors. I have occasional debates with other experts on how many colors should be used in a report, especially with those experts that have embraced the new metrosexual 'minimalist' look.
Thanks.
vbnetcoder
ASKER
I can't post the report because i would get in trouble with my client. The table i was talking about earlier was a table HOWEVER i was using the table as a legend for a chart. So, the first column was a square with the background using the switch statement and the second column was a description
I had to change to script a little so that i could share it but this gives the idea: