You can purchase directly from us to receive a 10% discount by clicking the buy now button above, or you can purchase from snowcovered.  You can also sign up for a subscription to get this module and all other products Module Masters has to offer. Download Demo Now!

SQL Reporting Services (2000 / 2005 / 2008)

This module allows you to interface your DotNetNuke portal with Microsoft SQL Server 2000,  2005 or 2008 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 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 DotNetNuke Marketplace.  Not only is it certified by them, it is used by them!

Features

• New (4.3) - Passing profile properties as parameters.
• New (4.2) - Encrypted Passwords & DNN IPortable Support
  New (4.1) - Support for regular expression filtering of reports
• New (4.0) - Support for SQL Reporting Services 2008 and new controls such as Tablix
• Report browser mode for easy report and folder navigation (SQL RS 2005/2008 only)
• Pass the report or folder via the Querystring (SQL RS 2005/2008 only)
• Specify parameter values from module settings
• Allow Passing UserId & PortalId via the Querystring
• Supports SQL Server Service Pack 2
• On report change, URL parameters ignored implicitely
• On report change, parameter bar maximized
• Support for more than one report server
• Support for passing portaladmin session variable (SQL 2005/2008 RS only)
• Updated report viewer control / bug fixes
• Report server connectivity testing during setup
• Allows turning the parameter bar off via a URL parameter
• Suports SQL server session state
• Updated documentation
• Accepts report parameters as URL parameters (SQL 2005/2008 RS only)
• Passes PortalId and UserId as parameters (SQL 2005/2008 RS only)
• 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, SQL Reporting Services 2005 or SQL Reporting Services 2000.
• Allows users to select which reports they will run.
• Works with parameter driven reports showing a parameter bar for users to enter parameter criteria.

Server Configuration

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. servername/reportserver/reportservice.asmx). 

Username - This is the username to get authenticated to the reporting services, it is needed since most report services are using windows authentication.  The reports that will be shown will be specific to the privileges of the user you specify here.  Note: in SQL RS 2000, users may be prompted to authenticate to view reports, however SQL RS 2005 / 2008 will always authenticate based on the supplied credentials of the reporting server.

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 user.

Module Settings

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.

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 to be shown will be disabled.  Users will be presented with a combobox which they can choose the report to run at runtime.

Display Report Table Navigation - If you check this, a table will be displayed rather than a combobox allowing them to traverse 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.

Dispaly 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.

Report - If you do not allow users to select the report to run, you can specify which report will be run.

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.

Report Name Filter - 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 pixles 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 - Allows setting 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 mdoule settings.

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.

Stay tuned for more updates and enhancements.  We love to hear your feedback and ideas, so please drop us a line if you have any thoughts.