RTC - coding

bavanisenthil
bavanisenthil Member Posts: 7
edited 2010-08-31 in NAV Three Tier
How to do groupwise total in RTC?

please give me steps to do so..

Comments

  • brijeshvaidya
    brijeshvaidya Member Posts: 50
    First achieve the group wise total in classic report,
    for example : consider two tables(dataitems)1)sales header and 2) sales line.

    if it is working fine then write the code in the "OnAfterGetRecord()" trigger of the dataitem(table)'s code. add groupwise total field and show in the sales header table's footer section.

    after that come to rtc - report and add new group on the table.

    then group on sales header no.
    and in the footer of that group take the group total field which is coming from the classic client.
    it means the property of the groupwise total textbox->DataSetFieldName=xyz..

    so in the rtc.. u can get the groupwise total as =Fields!xys.Value
    Brijesh Vaidya
    Sr. Software Engineer
    India
  • bavanisenthil
    bavanisenthil Member Posts: 7
    Hi brijesh,

    Thanks a lot. its working fine.

    Having salesheader(dataitem1 ) and salesline(dataitem2). i want to group on
    1.department code
    2.project code

    i have add two group headers and group footers for both fields.
    Also in report, i want to add Rs.1000 on amount field, i wrote 'DVamount + 100' in body section .

    I want to display this calculated value in bth group footers and footersection also.

    i am output in classic. but in RTC, i am getting grandtotal value and not grouptotal

    how to do this brijesh??

Categories