Friday, September 26, 2014
Seeing the Dataset of a report can be very helpful, because it shows all values for every Data Item‘s column in one table. (Watch this video to see how the Dataset can be opened for reports in NAV.) It‘s useful to export this table to Excel and, with the help of filters, see how particular values are calculated. 1ClickFactory developers found this less time-consuming than adding test messages to the code of test controls in Layout. Most often, the Dataset Table is used to check total values. If your report was transformed using 1ClickFactory Report Transformation Service and function CurrReport.CREATETOTALS was used in that report, then you may have to take some actions to re-implement that functionality. The three most common things we do to re-implement the CurrReport.CREATETOTALS function are:
- Use the function SUM in Visual Studio
- Use the function LAST in Visual Studio
- Create new Global Variables in NAV and use them in C/AL code to count the total values. Then add those Global Variables as a Column in adequate data item and use them in Visual Studio as a source expressions.
There is no straightforward rule to identify which of these three options should be selected. If, after transforming your report using 1ClickFactory Transformation Service, the total fields in your report are not calculated correctly, 1ClickFactory developers recommend opening the Dataset of your report, checking how the total values are calculated, and then decide which of these three options are suitable in your case.