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. 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 10.0) Updated to the SQL Reporting Services 2016 Report Viewer control
- (New in 10.0) Added support for DNN 9.X
- Added support for DNN Evoq & 8.X platform
- Added ability to specify export file name
- Added support for SQL Reporting Services 2014
- Added unlimited use for dnndev and localhost testing sites
- Added support for off-line trial activation
- Added quick link to module settings
- Added DNN Role folder and report level security
- Added option for opening reports in the same or new pop-up window
- Added support for Azure hosted sites
- Added support for Azure SQL Reporting
Installation simplified, no need to modify web.config any more
Chrome calendar control fixed
DNN 7 styling and compatibility conflicts corrected
Rewrite of the module using DNN 6 manifest architecture, module renamed from RS2005 to SSRS
Localization of the date parameter bar
Drop down calendar control support for Chrome browser
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
Support for SQL Reporting Services
new controls such as Tablix
Report browser mode for easy report and
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 through 2017 (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.
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 & Azure
- 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 screen-shot 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.
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
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.
also important to note that if you are using SQL Server Express, the
Express edition of reporting services only supports PDF, Word and Excel
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
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
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
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
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.
- 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
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.
- 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.
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
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
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 2017 through 2008.
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!