maverick00
asked on
Highlight every other Project ID not every other row
I want to highlight every other ProjectID row in my detail section of my report.
I know how to highlight every other row in the detail section but would rather see it highlight every other project ID - which could have any number of rows.
In the below example: (I have suppress if duplicated on the ProjID) I would like to see all of ProjID 2 highlighted as a group and ProjID 1 and 3 would just be the crNoColor. I tried moving all my fields to the ProjID group header but I got weird results.
ProjID Date Comment
1 1/7 blah blah
1/6 blah blah
2 1/7 lkjl;kj;lkjlkj
1/6 asdfasd
1/5 asdfasdf
3 1/7 lkjlkjsadfk
1/5 lkjlkjl;kjl;kj
I know how to highlight every other row in the detail section but would rather see it highlight every other project ID - which could have any number of rows.
In the below example: (I have suppress if duplicated on the ProjID) I would like to see all of ProjID 2 highlighted as a group and ProjID 1 and 3 would just be the crNoColor. I tried moving all my fields to the ProjID group header but I got weird results.
ProjID Date Comment
1 1/7 blah blah
1/6 blah blah
2 1/7 lkjl;kj;lkjlkj
1/6 asdfasd
1/5 asdfasdf
3 1/7 lkjlkjsadfk
1/5 lkjlkjl;kjl;kj
Currently I am just using this to color every other row.
IF Remainder(RecordNumber,2)=0 THEN RGB(219,219,219) ELSE CrNoColor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just drop the formula onto the report header section not in the color formula.
mlmcc
mlmcc
ASKER
Thanks! That worked!
ASKER
Thanks.