rdlc report nav 2015

paulolemungai
Member Posts: 16
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
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
0
Best Answer
-
5
Answers
-
I have set group to break per page but the sum get growing as pages increase0
-
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/0 -
[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!0 -
still stuck anyone to help will appreciate the totalbonus is a new data column created want to sum on each page separately0
-
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.0 -
yes i have the sum function how can i reset
in the page0 -
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
0 -
paulolemungai wrote: »yes i have the sum function how can i reset
in the page
Can I see your tablix on RDLC layout?0 -
5
-
there
0 -
will be waiting for your feedback
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions