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