Trouble with several fields in GroupTotalFields

randrews · 2005-01-11

Suppose, I have Table with key Field1,Field2,Field3,...

And I want to group by
GroupTotalFields = Field1,Field3 with key (above)

But report grouping as GroupTotalFields = Field1,Field2,Field3 in section with onpre triger:
CurrReport.SHOWOUTPUT(FIELDNO(Field3) = CurrReport.TOTALSCAUSEDBY);

Can I make results by standart grouping way, avoiding to create key Field1,Field3.
Or it is necessarily incredible variable

kine · 2005-01-13

you must create the correct key, because the grouping is called when one value in the group field is changed...

assume this:

  Field 1, Field 2, Field 3
  1,1,1 - Group 1 (1,1)
  1,1,2 - Group 2 (1,2)
  1,2,1 - Group 3 (1,1)
  1,2,2 - Group 4 (1,2)
  2,1,1 - Group 5 (2,1)
  2,1,3 - Group 6 (2,3)
  2,2,1 - Group 7 (2,1)

it is Sorted with Field 1, Field 2, Field 3 key. If you want group by Field 1, Field 3 for each record will be group section called because Field 3 is still changing his value. You must sort it in this way>

  Field 1, Field 3 sorting
  1,1,1 \
  1,2,1 - group 1 (1,1)
  1,1,2 \
  1,2,2 - group 2 (1,2)
  2,1,1 \
  2,2,1 - group 3 (2,1)
  2,1,3 - group 4 (2,3)

randrews · 2005-01-13

Thanks a lot for reply.
Its precisely that I want.

Trouble with several fields in GroupTotalFields

Comments

Categories