compare current record with next record

Curtis2009
Curtis2009 Member Posts: 13
edited 2009-11-09 in NAV/Navision Classic Client
Hi all, im running a report where i need to compare one field of the current record with the same field in the next record.

The data is like this:

rec 1 type A
rec 2 type A
rec 3 Type B

When the type changes to B i need to show subtotals section in the report, and after that reset them. Any help will be aprecciated. :-k

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Sounds like this is more of a Grouping question then comparing
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Curtis2009
    Curtis2009 Member Posts: 13
    Thanks for the reply. Yes i could solve my problem with grouping, but i need to reset the subtotals and have no idea how to do that :-k .
  • sunnyk
    sunnyk Member Posts: 280
    See Total fields property of Dataitems. :D
  • vijay_g
    vijay_g Member Posts: 884
    hi,
    Here you have to set key with grouping field and then total field write in total field property of same dataitem this will automatically set and reset the value of total field.

    in case of multiple grouping you have to use TOTALCAUSEDBY function on trigger.

    Vijay Gupta

Categories