Rdlc report total issue

Business Central/NAV Developers Forum
1

Hey,

On my report i have 2 tables which prints items and resources. And in those tables i also have unit prices and the total of unit price at the table footer. My issue however, is that when i’m trying to calculate the total of itemUnitTotal + ResourceUnitTotal and prinit it to a textbox almost my result is double up, i get wrong result. Does anyvody have a better way of solving this issue?

Thanks

2

Below are few methods you can use to resolve the issue :

  1. Try using Scope for calculating sum. Eg : Sum(Fields!UnitPrice.Value,“Tablix1”)

  2. SSRS code to calculate Sum. Check blogs.msdn.microsoft.com/…/

  3. Calculate the total in C/AL and display it in report

3

Thank you, that helped

4

Am having the same issue am calculating the total using c/al on the first filters by the group works well but when i have group of people whom am grouping with keeps summing all the way from page one per person to the last person not breaking