Comparing RDL and RDLC

In this section, I will compare RDL and RDLC. Both technologies have their advantages and disadvantages and it is important to remember how to get the maximum out of both of them.

SSRS	Dynamics NAV RTC Reports
RDL	RDLC
Runs on SQL Server	Runs on Workstation/Laptop (Client)
Define Query in SQL: T-SQL Views Stored Procedures Functions, DMV, DMF, …	Define data items in Classic Report Designer: Data Item(s) C/AL Code Views via Linked Object(s)
Multiple Datasets	Always one DataSet
Multiple DataSources (OLAP, OLTP, Other, …)	Always one DataSource
Can query multiple companies	Always one Company
No Flowfields, FlowFilters available. Instead you can create a SQL subquery, view, function, stored procedure,…	Can use FlowFields and FlowFilters
No multilanguage functionality, possible via: Expressions, View, Translation Table…	Multilanguage functionality out of the box
Parameters in report	Parameters in Request Page
Toolbox contains more items and data regions...