Adding totals on decimal field
As the reporting solution is changed, most of the old functions are either removed or replaced. The next small recipe will show you a very basic but widely used function to get a total.
How to do it...
First, create a report by following the Creating an RDLC report recipe.
Open the report in the designer mode and navigate to View | Layout (Alt + V, Y) to alter the report visual layout.
Select the last row of the table control, right-click and navigate to Insert Row | Outside Group – Below.
In the newly added row, right-click on the cell of column
Balance_Customerand select Expression.Set the following value for the expression as you reach a form similar to the following screenshot:
=SUM(Fields!Balance_Customer.Value)
Save and close the report.
How it works...
In NAV classic reporting, we used to set the data item property TotalFields or function CREATETOTALS. As both these options are not available for the NAV 2013 report, we need to base our report totals on Visual...
