Designing server-side reports in SQL Server Reporting Studio
In the next recipe we will create a report based on NAV data, but not connected to the NAV server or client in any way. Server-side reports, as the name implies, are rendered on the server and published on a web portal through IIS server. Users can access these reports simply in a web browser from any computer connected to the corporate network.
The process of developing a server-side report is very similar to creating a client-side one, except that the source dataset is provided by an SQL query instead of a NAV server instance.
In source files: folder NAV Report
, Visual Studio solution NAVReport.sln
.
Getting ready
Download and install SQL Server Data Tools for your version of Visual Studio. The SSDT package is available on MSDN.
Internet Information Services must be installed and running on the computer that the report is going to be deployed on.
How to do it...
The report developed in the recipe shows the top 5 customers generating...