rdlc report nav 2015

paulolemungai

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

wolfskin

I think this video will help you figure out the problem.

https://www.youtube.com/watch?v=KGa2iCv7m_A

paulolemungai

I have set group to break per page but the sum get growing as pages increase

RockWithNAV

You need to debug this it seems to be an incorrect execution issue OR somewhere its holding a wrong value!!

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

paulolemungai

still stuck anyone to help will appreciate the totalbonus is a new data column created want to sum on each page separately

wolfskin

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.

paulolemungai

yes i have the sum function how can i reset
in the page

paulolemungai

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

wolfskin

paulolemungai wrote: »

yes i have the sum function how can i reset
in the page

Can I see your tablix on RDLC layout?

wolfskin

I think this video will help you figure out the problem.

https://www.youtube.com/watch?v=KGa2iCv7m_A

paulolemungai

there

paulolemungai

will be waiting for your feedback