Quicklinks
	Click the credit card icon to purchase directly from us to receive a 10% discount or purchase from Snowcovered.
	Download the free 30 day fully functioning demo. Unzip the zipped package for the DNN PA.
	View the latest online documentation for the most recent released version.
	Access the forums to log any support requests and view the knowledgebase.

DotNetNuke SQL Reporting Services (SSRS) Module

This module allows you to interface your DotNetNuke portal with Microsoft SQL Server SQL Reporting Services (SSRS) 2005, 2008 or 2008 R2 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 5.1) Added async postback timeout setting and size to report setting
• (New 5.1) Added ability to specify session variables as parameter values
• (New 5.1) Updated download file to enable choice of which control to use
• (New 5.0) Auto open report in new window
• (New 5.0) Updated with new AJAX enabled report viewer control
• 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 2008/R2, SQL Reporting Services 2005
• 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 4.9.5 - 6.X (Note: support it is possible to get the module to run in older versions of DNN 4.X but we officially support the last stable release of this version)
• .NET 3.5 (for AJAX enabled control, .NET 2.0 for non AJAX enabled control)
• IIS 6, IIS 7/7.5
• Windows Server 2003 & 2008
• AJAX enabled within DNN (when using AJAX enabled control)
• SQL Reporting Services 2005 - 2008/R2
• 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, you 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:

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.

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.

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.

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

Viewing sample SSRS Report within DNN

Please note, starting in version 5.0 we have officially dropped support for SQL Reporting Services (SSRS) 2000.  Our module versions up through 4.3 still will support SSRS 2000 within DNN, but we are unable to provide much more than basic email support for these.

Stay tuned for more updates and enhancements. We love to hear your feedback and ideas, so please drop us a line via service@modulemasters.com 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!