SQL Reporting Services (9.0) Demo

posted by Module Masters - 1/21/2016
Module Masters Active Since 10/1/2005
United States

reviews Ask a Question

1 users are watching this product.

This module allows you to interface your portal with Microsoft SQL Server Reporting Services 2008/R2, 2012, 2014 and Azure SQL Reporting. 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 RS module for DNN! Module 35609

$0.00

Add To Cart
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 online documentation for the most recent released version.
Access the Module Masters Online Support Forums Access the forums to log any support requests and view the knowledge-base.
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 & Azure SQL Reporting Services. 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 9.0) Updated to the 2015 Report Viewer control
  • (New in 9.0) Added support for DNN Evoq & 8.X platform
  • (New in 9.0) Added ability to specify export file name
  • (New in 8.0) Added support for SQL Reporting Services 2014
  • (New in 8.0) Added unlimited use for dnndev and localhost testing sites
  • (New in 8.0) Added support for offline trial activation
  • (New in 8.0) Added quick link to module settings
  • Added DNN Role folder and report level security
  • Added option for opening reports in the same or new popup window
  • Added support for Azure hosted sites
  • Added support for Azure SQL Reporting
  • Installation simplified, no need to modify web.config anymore
  • Chrome calendar control fixed
  • DNN 7 styling and compatibility conflicts corrected
  • Rewrite of the module using DNN 6 manfiest architecture, module renamed from RS2005 to SSRS
  • Localization of the date parameter bar
  • Drop down calendar control support for Chrome browser
  • Integration with the DNNSharp MyTokens module
  • Async postback timeout 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 2008 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.
  • Interfaces with Microsoft SQL Reporting Services 2014, 2012, 2008/R2 and 2005 (see documentation for which module version supports which version of SQL Reporting Services)
  • 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 6.X - 8.X (Note: support 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.0
  • IIS 6, IIS 7/7.5/8
  • Windows Server 2003, 2008, 2012 & Azure
  • AJAX enabled within DNN (when using AJAX enabled control)
  • SQL Reporting Services 2000, 2005, 2008/R2, 2012, 2014, Azure SQL Reporting (See documentation for which module version supports which version of SSRS)
  • Internet Connection for Activation (Note: for web servers not connected to the internet, offline 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 screenshot of the server administration options:

Module Masters DNN SSRS Server Settings Screenshot

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

Report Server- You must choose which report server to connect to. The servers are setup from the Server Administration screen.

Report Folder - Here you specify the folder you want to see the reports within. This information is fed from the report server.

Allow user to select report - If you check this, the option to select a specific report will be disabled and users will receive either a drop down box or table view to select a report from when viewing the module. If this option is not checked, underneath the Report Folder will be the option to select a specific report within that folder to be displayed.

Display Report Table Navigation - This option is only displayed if the "Allow user to select report" option is checked. If you check this, a table will be displayed rather than a combobox allowing users to select a report from the selected folder structure selected.

Display Folder Name - A link is displayed at the top of the report table navigation that shows the report folder you are in, you have the option of turning this feature off.

Display Report Name - The name of the report that is selected can be displayed at the top of the report or it can be turned off.

Auto Export Report - This option allows you to automatically export a report to a specified format. In order for this to work, all the available parameters for the report must be supplied via report defaults, the parameters section within the module settings or via the URL. It is also important to note that if you set the module up to render a specified report, a warning message will be displayed indicating that the page with the module will no longer be displayed. Now when you browse to this page, the save report dialog will be displayed rather than the page itself. In essence, the page becomes a download link for the chosen report. The only way to get back to that page and view the report and to get to the settings is to add to the page a querystring parameter of NoExport=true (e.g. http://yourserver.com/page/tabid/53/Default.aspx?NoExport=true or http://yourserver.com/Default.aspx?TabID=53&NoExport=true). It is also important to note that if you are using SQL Server Express, the Express edition of reporting services only supports PDF, Word and Excel exporting.

Export File Name - This option only is visible when you select the "Auto Export Report". The string entered here will be used as the file name when the report is exported. This stirng can contain tokens or literal text. The same tokens that are available to be passed in as report parameter values can be used here. Please see the "Parameters" explanation below for more explanation on token usage.

Show report back button -This shows the back button within the report that is displayed which supports report navigation.

Show export options - Reports can be exported to Excel, PDF and other formats, this shows the control which enables reports to be exported.

Show find control -You can search for text within a report that is run, this shows the find control that enables this ability.

Show report page navigation bar - Reports may contain several pages, this will show the navigation bar that allows you to navigate between pages.

Show report print button - Reports can be printed using a special print control, this will show this control.

Show report refresh button -Reports can be refreshed from within the module itself, this enables the refresh button to appear within the report module.

Show report zoom controls - You can zoom from within the report module itself.

Parameter Prompt Area Collapsed - If this is checked and your report has parameters, the parameter input area will be collapsed. There is a parameter expand button that can be clicked to make it visible so users can alter the parameter values.

Size to Report Content - When checked, the control will grow to fit the report contents. This behaves differently in different browsers so use with caution. It is possible that the report content expand beyond the container and skin elements within DNN. You need to use a combination of interactive height / width in the RDL for the report definition to define page sizes and take into consideration the module settings for zoom type when turning this feature on.

Show Document Map Button - For reports which have navigation defined, a document map can be displayed. This button allows toggling it to be displayed or hidden. You can choose to hide this button.

Document Map Collapsed - The document map can be collapsed by default by checking this.

Document Map Width - The document map default width can be set by entering a pixel value or a percentage.

Async Postback Timeout - This setting determines how long in seconds the browser will wait for a report to run. The default value for this is 90 seconds. If a report runs longer than the time specified time, a javascript timeout error message will be thrown. Note: If users have javascript errors disabled, they may not see the timeout message.

ReportName Filter - This option is only displayed if the "Allow user to select report" option is checked. Here you can specify a filter for inclusion or exclusion to filter reports based on the report name. This allows you to hide or display a subset of reports from the reporting server directory based on the powerful regex syntax.

Report width - You can specify how wide you want the module to be. You can specify the number of pixels or use a percentage.

Report height - The height in pixels of the report module.

Zoom mode - You can set the default zoom level of the module. The options or PageWidth, FullPage or a Percent. If you specify PageWidth, the report is zoomed to the width of the reports outer edge. If you specify full page, it will zoom to show the entire page 1 of the report. If you specify a Percent, you must set a percentage to set the zoom level to (e.g. 75).

Allow Pass UserId and PortalId via URL - Specifies that the parameter for PortalID and UserID may be passed in as a querystring parameter for reports. This will override the logged in user with the values that are passed. This feature is turned off by default for security reasons.

Parameters - This section allows setting an unlimited number of parameters and values for those parameters at a module level. The parameters and values specified here will be matched to any report displayed within the module and the value will be substituted if a parameter name is matched to a parameter specified in the module settings. You can specify literal values or leverage user profile tokens including custom profile tokens. Tokens must be surrounded by brackets [] and must match exactly the name of a user profile token. For instance, if you had a custom user profile property "test", the parameter value would be set to [test] and the value from the user profile would be substituted at runtime for the specified report parameter. Parameters are case sensitive so the case of the parameter name must match what is specified in the report definition.

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

Reporting Services SSRS DNN Permissions

Reporting Services SSRS DNN Permissions

Additional Screenshots

These 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
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 9.X supports SQL Reporting Services 2014 through 2008.

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