Chapter 3. Reporting and Data Analysis
In this chapter we will cover the following recipes:
- Designing reports in Visual Studio
- Developing Word layout for RDLC reports
- Writing C/AL code in a report
- Designing the report request page
- Writing RDLC code in a report
- Using built-in expressions in the report layout designer
- Including user interaction in reports
- Updating NAV data with the Excel add-in
- Retrieving data from NAV with Power Query
- Creating pivot tables with Power Query
- Analyzing data with Power BI
- Data hierarchies in Power BI reports
- Statistical data analysis in Power BI with R
- Sales forecast in Power BI with R
- Designing server-side reports in SQL Server Reporting Studio