rdlc report nav 2015

I have declared TotBonusClasses as a new virtual table where it calls values and adds them to my report
and a code
IF "Posted Settlement Add./Ded.".Code IN THEN
BEGIN
TotBonusClasses:=TotBonusClasses + Amount;
CurrReport.SKIP;
END;

IF "Posted Settlement Add./Ded.".Code IN THEN
BEGIN
TotBonusClasses2:=TotBonusClasses2 + Amount;
CurrReport.SKIP;
END;

but when call in this in report does the calculation correctly in the first page but on other reports keeps summing the data as it grows please help

Best Answer

Answers

  • paulolemungaipaulolemungai Posts: 13Member
    I have set group to break per page but the sum get growing as pages increase
  • RockWithNAVRockWithNAV Posts: 748Member
    You need to debug this it seems to be an incorrect execution issue OR somewhere its holding a wrong value!!
  • krikikriki Posts: 8,570Member, Moderator
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • paulolemungaipaulolemungai Posts: 13Member
    still stuck anyone to help will appreciate the totalbonus is a new data column created want to sum on each page separately
  • wolfskinwolfskin Posts: 12Member
    I think you may need to reset the "TotBonusClasses" and "TotBonusClasses2" values when the group is changed to avoid the accumulation.

    Or use SUM function on RDLC if you've already added the group on the tablix.
  • paulolemungaipaulolemungai Posts: 13Member
    yes i have the sum function how can i reset
    in the page
  • paulolemungaipaulolemungai Posts: 13Member

    Hi wolfskinI think you may need to reset the "TotBonusClasses" and "TotBonusClasses2" values when the group is changed to avoid the accumulation.

    how do i do this i have set break page in the tablix



  • wolfskinwolfskin Posts: 12Member
    yes i have the sum function how can i reset
    in the page

    Can I see your tablix on RDLC layout?
  • paulolemungaipaulolemungai Posts: 13Member
    l4tachhyxlpp.png
    mbycnxzvm6dc.png

    there

  • paulolemungaipaulolemungai Posts: 13Member
    will be waiting for your feedback

Sign In or Register to comment.