The report server handles all data retrieval and processing.
Microsoft Report Viewer is a set of controls and runtime components that allow applications to display reports designed with Microsoft Reporting technologies (RDLC for local reports and RDL (server reports) when connected to SQL Server Reporting Services). It provides an embeddable report-rendering experience for Windows Forms, ASP.NET Web Forms, and (via wrappers) some newer application types. Typical uses: previewing, printing, exporting (PDF/Excel/Word/CSV), parameter prompting, and simple interactivity (drillthrough, toggles, sorting). microsoft report viewer