4.91 (11 product reviews.)

SQL Reporting Services (11.0)

posted by Module Masters - 11/10/2018
Module Masters Active Since 10/1/2005
United States

5.00

(1 total reviews for Module Masters in the last six months.)

reviews Ask a Question



This module allows you to interface your portal with Microsoft SQL Server Reporting Services 2008/R2 - 2017. This is a great way to bridge the gap between DNN and your SSRS server! This module is the longest running and most maintained SQL Reporting Services module for the DNN platform. Module 38575

$169.95

Add To Cart

Discounts

Version 10 Upgrade Discount - 40%   Get a 40.0% discount on SQL Reporting Services (11.0) when you order SQL Reporting Services (10.0)
Version 9.0 Upgrade Discount - 30%   Get a 30.0% discount on SQL Reporting Services (11.0) when you order SQL Reporting Services (9.0)
Version 8.0 Upgrade Discount - 20%   Get a 20.0% discount on SQL Reporting Services (11.0) when you order SQL Reporting Services (8.0)
Quick Links
Download SRS DNN Module from Module Masters Download the free 30 day fully functioning demo. Simply download and install this zip from the Extensions menu.
View the latest SSRS DNN Module Help View the latest on-line documentation for the most recent released version.
Last Updated: 10-Nov-2018

DotNetNuke SQL Reporting Services (SSRS) Module

Module Masters Reporting Services LogoThis module allows you to interface your DotNetNuke portal with Microsoft SQL Server SQL Reporting Services (SSRS) 2008, 2008 R2, 2012, 2014, 2016 & 2017. 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!

Features

  • (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
  • (New in 10.0) 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
  • 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, 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 parameters.
  • Encrypted Passwords
  • 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.

Requirements

  • Supports 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.X on)
  • .NET 3.5 / 4.x
  • Minimum IIS 6
  • Windows Server 2003, 2008, 2012, 2016
  • 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)
  • Internet Connection for Activation (Note: for web servers not connected to the internet, off-line activation can be done, please see the documentation for instructions)

Using the Module - Register SSRS Server

The module is easy to use. After installation, modify the web.config to 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 screen-shot of the server administration options:

Module Masters DNN SSRS Server Settings Screen-shot

Server Version - 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. http://servername/reportserver).

Username - This is the active directory username to get authenticated to the reporting services, it is needed since most report services are using windows authentication.

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.

Module Configuration

Once you have a server registered, you can then start adding instances 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.

Reporting Services SSRS DNN Settings

Please see our documentation for further explanation of the settings displayed within the Module Configuration section.

Report Permissions

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 screen-shots demonstrate how this is configured.

Reporting Services SSRS DNN Permissions

Reporting Services SSRS DNN Permissions

Additional Screen-shots

These screen-shots 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
DNN SSRS Report Directory Listing View

Viewing sample SSRS Report within DNN
DNN SSRS View Sample Report

Please 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 2017 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 [email protected] if you have any thoughts. Most of the new features we implement are customer driven ideas.  We also offer custom solutions based on your needs, contact us today for more information!

 

Product License

Licensed Per DNN Instance

Licensed Per DNN Instance

Product Badges

Azure Compatible

Categories

Spotlight Reviews

4.9 4.9 (10 product reviews)
Gary T says... 5 5.0
Excellent module.
Posted 2/24/2012
Eric D says... 5 5.0
Works great! Would reccomend to anyone.
Posted 12/8/2011
Lars S says... 5 5.0
Works, does what it should, cheap.
Posted 4/23/2008
Andrew Z says... 5 5.0
Module Masters provides excellent products and outstanding support. They quickly responded and addressed any questions I had (even unrelated to their... Show More
Posted 10/31/2006
Kevin S says... 5 5.0
Talk about service! These guys are AWESOME... returned my request within minutes and made sure I was satisfied!! I'd give this company a 100 stars... Show More
Posted 10/20/2006

Show More Reviews