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 Member Posts: 16
    I have set group to break per page but the sum get growing as pages increase
  • RockWithNAVRockWithNAV Member Posts: 968
    You need to debug this it seems to be an incorrect execution issue OR somewhere its holding a wrong value!!
  • krikikriki Member, Moderator Posts: 8,914
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)
  • paulolemungaipaulolemungai Member Posts: 16
    still stuck anyone to help will appreciate the totalbonus is a new data column created want to sum on each page separately
  • wolfskinwolfskin Member Posts: 82
    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 Member Posts: 16
    yes i have the sum function how can i reset
    in the page
  • paulolemungaipaulolemungai Member Posts: 16

    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 Member Posts: 82
    yes i have the sum function how can i reset
    in the page

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

    there

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

Sign In or Register to comment.