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!
The demo version is fully functional and can be implemented in your portal. After the demo period is over, the module can easily be converted over to the fully functional version without losing your settings. |
|
Features
-
New (4.3) - Passing profile properties as parameters.
New (4.2) - Support for Iportable interface for import / export of module settings
-
New (4.2) - Added encryption for server credentials
-
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 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 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.
We pride ourselves on our support, just checkout our statistics on ModuleMasters. Also please read some of the reviews from 1.2 here as well as reviews for our other releases here on snowcovered. This is the fourth generation of this product. It has a large market prescense and is used in hundreds of installations around the world powering reports within DNN on many high volume sites.
Download the demo and find out more at ModuleMasters.com
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.
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 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 / PortalId via URL - Normally the PortalId and UserId are not available to be passed in via the querystring, however if you select this, you can provide these to a report via the URL.
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.
View 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.