DYNAMICS NAV REPORTS USING SSRS
SQL Server Reporting Services (SSRS)
is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).
A report object is composed of a the following items:
- Report dataset.
- Report layout.
- Request page.
- Properties, triggers and code.
You design a report by first defining the dataset, and then designing the visual layout. SSRS works on the server, so it’s faster. And this is especially true when reports get complex. SSRS allows you to use stored procedures to save time. SSRS, as a server-only application, is also great for the cloud.
SQL Server Report Service (SSRS) reports exist entirely outside of the Navision environment, but are accessible to Navision via their URL. 22 Free Reporting Services Reports for Dynamics Nav available.
Running SSRS reports from the same server as Navision services or applications run will add a certain amount of processing burden on the server. If there are already many users on the server, the burden may be noticeable. If so, it may be advisable to move the SSRS reporting to another server.
SSRS reports can be distributed via SSRS subscriptions, can be distributed in multiple forms, and can be integrated with SharePoint.
Our research determined that SSRS reporting requires true RDL - meaning that a dataset must be present within the RDL definition.