Wrong data in GroupFooter
I have following report with 3 levels of group headers/footers :
And this data :
Sometimes (it seems when there is no data for next "Master", Master3 in the example), the GF 1 displays data of the wrong Master. In the example, GF 1 of Master 2 shows data from Master 3 instead of Master 2.
What do I do wrong ?
Thanks,
FR 5.5 on D2010
GH 1 (Master)
  GH 2
    GH 3
      Data
    GF 3
  GF 2
GF 1 (Master)
And this data :
Master 1
  Data line 1
  Data line 2
Master 2
  Data line 1
Master 3 - No data
Master 4
  Data line 1
Sometimes (it seems when there is no data for next "Master", Master3 in the example), the GF 1 displays data of the wrong Master. In the example, GF 1 of Master 2 shows data from Master 3 instead of Master 2.
What do I do wrong ?
Thanks,
FR 5.5 on D2010
Comments
you probably should be using true nested groups with data supplied from 1 query across all tables
with the orderby cclause of the query matchin the order of the group header criteria
gh1
gh2
gh3
md band
gf3
gf2
gf1
see the main demo nested group report
I have prepared a very simple project demonstrating the problem. There is no code. Just open the report and preview it. As you can see, the groupfooter that corresponds to Master2 shows "Master3".
Project attached.