mibuso.com
Home› NAV Three Tier
Options

rdlc report nav 2015

paulolemungaipaulolemungai Member Posts: 16
in NAV Three Tier
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

  • Options
    paulolemungaipaulolemungai Member Posts: 16
    I have set group to break per page but the sum get growing as pages increase
  • Options
    RockWithNAVRockWithNAV Member Posts: 1,139
    You need to debug this it seems to be an incorrect execution issue OR somewhere its holding a wrong value!!
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • Options
    krikikriki Member, Moderator Posts: 9,096
    [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!

  • Options
    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
  • Options
    wolfskinwolfskin Member Posts: 84
    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.
  • Options
    paulolemungaipaulolemungai Member Posts: 16
    yes i have the sum function how can i reset
    in the page
  • Options
    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



  • Options
    wolfskinwolfskin Member Posts: 84
    paulolemungai wrote: »
    yes i have the sum function how can i reset
    in the page

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

    there

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

Sign In or Register to comment.