The SQL Reporter is a private assembly (PA) that provides a tool for displaying a SQL Reporting Services Report or a list of available reports. This module allows the reporting server functionality to be built into the DotNetNuke portal framework, allowing a very high level of integration. Supports DotNetNuke ver 4.4 and above.

There are many display options available which provides a highly configurable environment to build for the reports. One option allows users to select their required report from a list of available reports. This provides the user with considerable control over their environment.

Reports that require parameters will work well with this module. The parameters are simply entered as the report is generated.

Uses:

• Integrate SQL Reporting Services Reports tightly into your portal.
• Allow reports from different SQL Servers to be displayed on the one page.
• Provide users with the ability to select from available reports without giving them direct access to the SQL reporting server.

Features:

• Allows SQL 2005 and SQL Express reports to be displayed within the DotNetNuke portal.

• Supports multiple report servers.

• Allows multiple connections to the same report server with different credentials.

• Report servers are configured per DotNetNuke portal instance, not the module instance.

• Fully supports DotNetNuke portals.

• Allows configuration of various options for display of report.

• Provides many options for sizing of the report display.

• Validates server connection settings during configuration.

• Allows user selection of available reports.

• Ability to pass the DotNetNuke values of PortalID, Username and UserID across to reports automatically as parameters for the report.

Screenshots:

The following screenshot shows a report being displayed.

The following screenshot displays the listing of servers configured for use with this module.

The following screenshot displays the details that can be set for each report server configured with this module. (The server settings are portal wide.)

The following screenshot displays the options that can be set for each report displayed using this module.