SSRS Module

DotNetNuke SQL Reporting Services (SSRS) Module

This module allows you to interface your DotNetNuke portal with Microsoft SQL Server Reporting Services (SSRS) 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, & 2022. You allow users to select which reports to run, or you can specify exactly which report will be shown within the module — a great way to transparently bridge the gap between your DNN portal and your SQL reporting server.

Chosen by DotNetNuke Corporation to power the reports used in the original DotNetNuke Marketplace. Not only is it certified by them — it is used by them!

Features

New 13.0 Added support for DNN 10
New 13.0 Added support for Reporting Services 2022
New 13.0 Updated to latest report viewer control
Table styling classes for customizing report table listing
Ability to force DNN report permissions for viewing folders and reports
Ability to enter tokens in the report filters (e.g. [UserId])
Ability to rename the report title with tokens or literal text
Support for DNN / Evoq 6.X – 9.X
Export and specify export file name including token support
Unlimited use for dnndev and localhost testing sites
Support for off-line trial activation
DNN Role folder and report level security
Open reports in the same or new pop-up window
Installation simplified — no need to modify web.config
Localization of the date parameter bar
Integration with the DNNSharp MyTokens module
Specify async post back time-out setting and size to report setting
Ability to specify session variables as parameter values
Auto open report in new window
Support for more than one SSRS server, including different versions
Auto export to specified format at runtime
Implicit tab properties passed as parameters (tabid, tabname, etc.)
Passing custom profile properties as parameters
Encrypted passwords
DNN Import / Export support
Support for regular expression filtering of reports
Report browser mode for easy report and folder navigation
Pass the report or folder via the querystring
Specify parameter values from module settings
Allow passing UserId & PortalId via the querystring
Report server connectivity testing during setup
Allows turning the parameter bar off via a URL parameter
Supports SQL Server session state
Accepts report parameters as URL parameters
Completely customizable display options

Requirements

Using the Module — Register an SSRS Server

After installation, modify web.config to add the handler, then add an instance of the module to a page and go to Server Administration to register one or more report servers.

Server Administration Settings

Server Administration screenshot
Server Administration — register and configure your SSRS server connection

Module Configuration

Once a server is registered, add module instances to pages and customize which report(s) are displayed.

Module Configuration screenshot
Module Configuration — customize how the module appears in your portal

Report Permissions

If the module is configured to allow users to select reports, you can set up report permissions to restrict which folders and reports are visible based on DNN role.

Report Permissions configuration
Report Permissions — folder-level security configuration
Report Permissions example
Report Permissions — report-level role assignment

Additional Screenshots

SSRS report directory listing within DNN
Directory listing of SSRS reports within DNN
Viewing SSRS report within DNN
Viewing a sample SSRS report within DNN

Version Notes

Note: Starting in module version 5.0, support for SQL Reporting Services 2000 & 2005 has been dropped. The latest version 10.X+ supports SQL Reporting Services 2008 through 2022. Azure SQL Reporting is no longer supported as Microsoft has discontinued that service.

We love to hear your feedback and ideas — please drop us a line at service@modulemasters.com. Most new features are customer-driven ideas. We also offer custom solutions — contact us today for more information!