I know this has been probably been asked a zillion times before, but I've been searching and have been unable to find a previous thread.
I want to altnernate the dynamicbackcolor between two colors based on groups of records, not every other record. The grouping can be based on any of several columns depending on how the user is doing a lookup for that instance, and these groups can have varying amounts of records as follows:
Grouped by UPSINO:
UPSINO
00001 <---Green
00001 <---Green
00002 <---White
00002 <---White
00002 <---White
00002 <---White
00003 <---Green
00003 <---Green
00003 <---Green
How do I achieve this through DynamicBackColor?
Thank you.