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
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
Comments
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
Sr. Software Engineer
India
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??