.. or I'm even dumber than generally accepted.
Have a look at the attached image.
This is from the detail section of a report. The detail section contains a crosstab (highlighted in Red.
Now, The crosstab has 2 row groups (and the content of these in show in bold).
I've been trying to find a way of getting the whole row
for each top-level row group to be formated with the same background colour.
Id cracked it by doing this in code ...
TabCount = 0;
sender, EventArgs e)
textBox25 is the textbox holding the top-level grouping value.
I then, for both row groups and the detail section, set up a Conditional Formating rule with Filter="=GetTabCount() % 2" Condition = "Equal" an Value = "=1".
As you can see from the screen shot, this works for the row group cells but not for the detail cell.
I did a test and got the system to echo the value of GetTabCount() for each of the cells in the crosstab and got:
0 - 0 - 3
1 - 1 - 3
2 - 2 - 3
And I'll be damned if I can figure out why.
It seems that textBox25 is being bound more often that I think it should (so I guess my understanding og that is wrong too) and that the detail cells are being bound after the all
of the row grouop cells on all of the rows.
Simply formating a report shouldn't be this hard.
If anyone can off any help, I will very