Trouble with several fields in GroupTotalFields

Comments

• Options

  kine Member Posts: 12,562

  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)
  

  Kamil Sacek
  MVP - Dynamics NAV
  My BLOG
  NAVERTICA a.s.

  0
• Options

  randrews Member Posts: 135

  2005-01-13

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

  0