DotNetNuke SQL Reporting Services (SSRS) Module
module allows you to interface your DotNetNuke portal with Microsoft
SQL Server SQL Reporting Services (SSRS) 2008, 2008 R2, 2012, 2014, 2016,
2017 & 2019. You allow users to select which
reports to run or
you can specify exactly which report will be shown within the module.
This is a great way to transparently bridge the gap between your DNN
portal and your SQL reporting server.
If you're looking to display SQL
Reporting Services reports in your portal, this module sets the
standard. As testimony, it was chosen by DotNetNuke Corporation to
power the reports that are used in the original DotNetNuke Marketplace.
Not only is it certified by them, it is used by them!
- (New in 12.0) Added table styling classes for customizing report table listing
- (New in 12.0) Updated control & support for SQL Server 2019
- (New in 11.1) Added option to force DNN report permissions for viewing folders and reports
- (New in 11.0) Updated to the SQL Reporting Services 2017 Report Viewer control, supports SSRS 2008 - 2017
- (New in 11.0) Enter tokens in the report filter (e.g. [UserId])
- (New in 11.0) Ability to rename the report title with tokens or literal text
- (New in 11.0) Bug fixes and deprecation of older features
- 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 any more
Rewrite of the module using DNN 6 manifest architecture, module renamed from RS2005 to SSRS
Localization of the date parameter bar
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, can even be different versions of reporting services
Auto export to specified format at runtime
Implicit tab properties passed as parameters (e.g. tabid, tabname, tabtitle, tabdescription)
Passing custom profile properties as
DNN Import / Export Support
Support for regular expression filtering of reports
Support for SQL Reporting Services new controls such as Tablix
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
Support for more than one report server
Support for passing portaladmin session variable
Report server connectivity testing during setup
Allows turning the parameter bar off viaa URL parameter
Supports SQL server session state
Accepts report parameters as URL parameters
Passes PortalId and UserId as parameters
Completely customizable on how you want the module to fit within your portal. You can specify a number of different display options that allow the module to adapt to your viewing preferences.
Allows users to select which reports they will run.
Works with parameter driven reports showing a parameter bar for users to enter parameter criteria.
DNN / Evoq 6.X - 9.X (Note: it is possible to get the module to run
in older versions of DNN but we officially support DNN 6.2.9 on)
- Minimum .NET 4.6
- Minimum IIS 6
- AJAX enabled within DNN (when using AJAX enabled control)
- Minimum SQL Reporting Services 2008/R2 (See documentation
for which module version supports which version of SSRS)
Connection for Activation (Note: for web servers not connected to the
internet, off-line activation can be done, please see the documentation
Using the Module - Register SSRS Server
The module is easy to use. After installation, modify the
add the handler, then simply plop an instance of it onto a page and
then go to Server Administration to register one or more report
servers. Below is a screenshot of the server administration options:
- Here you select the server version of your SQL reporting services
instance. Doing this adjusts the settings that will be visible based on
the instance type.
Report Server URL - The URL
to the report server. You can specify just the URL to the report server
or you can specify the full path to the reporting web service (e.g.
Username - This is the
active directory username to get authenticated to the reporting
services, it is needed since most report services are using windows
Domain - This is the
windows domain name. This setting is not required in all circumstances,
but in the event your server is not a domain controller or hosts
multiple domains, it may be needed.
Password - The password of the
reporting services active directory user.
Once you have a server registered, you can then start adding
of the modules to pages and customize each instance by choosing which
report(s) will be displayed. Here you can see the settings for
customizing how the module appears within your portal.
Please see our documentation for further explanation of the settings displayed within the Module Configuration section.
Once the report server is setup, if the module is configured to allow users to select which
report they want to run, it is possible to setup report permissions to restrict which folders
and reports are visible based on DNN role. The following two screenshots demonstrate how this
screenshots highlight a sample report viewed within the module and also
demonstrate how users (if given the ability) can see a selection of
reports which they can choose from the server.
Directory listing of
SSRS Reports within DNN
Viewing sample SSRS
Report within DNN
note, starting in module version 5.0 we have officially dropped support
for SQL Reporting Services (SSRS) 2000 & 2005 The latest module version 10.X supports SQL Reporting Services 2019 through 2008. Azure SQL Reporting is no longer supported since Microsoft has discontinued this service.
Stay tuned for more updates and enhancements. We love to hear
your feedback and ideas, so please drop us a line via firstname.lastname@example.org
if you have any thoughts. Most of the new features we implement are
customer driven ideas. We also offer custom solutions based
your needs, contact us today for more information!