Download DOWNLOAD
Forums FORUMS
Blogs BLOGS
Forge FORGE
Help HELP
Marketplace MARKETPLACE
DotNetNuke Home
You are here >   Development > Forge > Module - Reports
Register  |  Login
Purchase

DotNetNuke® Project :: Reports Module

The Reports module provides a simple, but flexible, view on data from your DotNetNuke Database. SuperUsers (aka "Host" users) can develop Reports by building a SQL Query and visualizing it with one of the Visualizers built-in to the module or a 3rd-party Visualizer.

How can you use the Reports Module?
  • Display a table of custom data from your Database
  • Display a list of Users in a specific Role
  • Display advanced queries that pull data from multiple tables
  • Display a chart of the number of users in each role
  • Display a report from SQL Reporting Services (EXPERIMENTAL)
Features: What can the Reports Module do now?
  • Display the results from any SQL Query in one of many ways:
    • a Grid
    • a Chart
    • an HTML-based template
    • an XSLT-based transformation
    • or anything else you want with the extensible Visualizer framework
  • Display reports from SQL Reporting Services
  • Import/Export Report Definitions through standard Import/Export Content
Roadmap: What are the future plans for the Reports Module?
  • Full support for the ASP.Net ReportViewer Control and SQL Server Reporting Services
  • Custom Parameters such as @PortalID, @TabID, @UserID that are filled in when the query is run
  • Custom Data Sources to enable the module to display reports containing data from:
    • Your DNN Data Provider
    • Other SQL-based Databases
    • XML Data
    • UDT Module Data
  • Allow SuperUsers to predefine a set of Reports that Admins can use (at this time, only SuperUsers can create Reports)
The project can be downloaded here

View_Blog

Jul 4

Posted by: Shaun Walker
7/4/2006 

As an Open Source project, one of the things we tend to ignore are the marketing activities which consume 50%+ of the time spent at traditional software product companies. This is largely because Open Source tends to focus more on solutions than hype, but it does lead to problems - especially when you are pitching your platform to the "decision maker" crowd ( who are more interested in objective collateral than source code ). I thought I would take a few minutes to provide a simple feature matrix comparison of DotNetNuke versus ASP.NET 2.0 versus SharePoint Server 2003 ( SPS 2003 ) versus Microsoft Office Sharepoint Services 2007 ( MOSS 2007 ). Why include information on so many products you ask ( and some which are not yet even released ) ? Well the reason is because we constantly get asked questions like "Why should I use DotNetNuke when we could use Microsoft 'X' ?" ( replace 'X' with whatever product  the Microsoft Marketing machine is pushing at that moment ). Obviously once you become familiar with DotNetNuke, and realize that a Web Application Framework has a very diverse set of strengths which you can leverage in your organization, your question will come full circle and more closely resemble "Why would I NOT use DotNetNuke when it delivers so much value at such a minimal cost?". Anyways, lets get on to the feature matrix:

Features Matrix Showdown

Feature DotNetNuke® ASP.NET 2.0 SPS 2003 and WSS 2.0 MOSS 2007 and WSS 3.0 DotNetNuke® Benefits
Usability
Portal Framework
(Extensible)

(Web Part Framework)

(Proprietary)

(Web Part Framework)
unlimited pages per site, unlimited modules per page, ability to display module on multiple pages
Browser-Based Administration  
Intuitive Control Panel      
Inline Editing, Drag and Drop        
Site Search   does not depend on third party components or services such as Index Server, etc...
Content Import/Export        
Templates       site and page templates ( with content ) supported
MS Office Integration      
Bundled Functionality
Announcements    
Blog      
Contacts    
Documents    
Events    
FAQs      
Feedback      
Discussion Forums      
Photo Gallery      
Html/Text Content    
IFrame    
Links    
Media      
News Feeds      
Custom Reports        
Directory        
Store        
Survey      
Custom Forms/Tables        
 
Banner Advertising        
Newsletters        
Event Logging        
File Manager        
Recycle Bin      
Membership & Roles
Plugin Membership Provider   support for all Microsoft Membership Provider attributes
Active Directory Authentication    
Internet/Extranet Authentication    
Public, Private, Verified Registration Options        
Plugin Roles Provider   additional support for Effective Date, Expiry Date, Avatars, Subscriptions, etc...
Security Role Trimming   role trimming control visibility at the Page, Module, and Folder level and also includes extensibility options for adding additional Permission types
User Profile
Plugin Profile Provider    
Extensible User Profile System   Profile items can be managed at run-time using an intuitive administrative interface. User interface controls generated automatically for collection of profile data.
Application Extensibility
Integrated Component Architecture
(Modules)

(Web Parts)

(Web Parts)

(Web Parts)
 
Rapid Development Model
(User Controls)

(User Controls)

(Server Controls)

(User Controls)
 
Developer Tool Support
(All VS2005 SKUs)

(All VS2005 SKUs)

(VS2003 Pro)

(VS2005 Pro)
supports FREE Visual Web Developer Express 2005 and SQL 2005 Express
Code Generation Templates       uses integrated Visual Studio item templates
Automated Packaging       integrated with standard application
Efficient Distribution       single ZIP file
Run-time Installation       integrated with standard application
Designer Extensibility
Templating Architecture
(Skins)

(Master Pages)

(Themes)

(Master Pages)
pre-compiled for maximum performance and flexibility
Design Tool Support

(VS2005)
 
(VS2005)
Supports ALL design tools ( PC and MAC )
Automated Packaging       integrated with standard application
Efficient Distribution       single ZIP file
Run-time Installation       integrated with standard application
Site Extensibility
Site Virtualization   supports multiple virtual sites from a single application/database based on URL
Friendly URLs     flexible RegExp URL Rewriting engine
Localization
Resource File Framework    
Run-time integrated editor        
Scalable       Does not use satellite assemblies ( satellite assemblies can cause memory consumption issues in hosted environments )
Automated Packaging       integrated with standard application
Efficient Distribution       single ZIP file
Run-time Installation       integrated with standard application
Security
Medium Trust Compliant        
Document Management
Secure Document Storage   supports storage on file system and in database
Infrastructure
XCOPY Deployment      
No IIS Customization      
Web Farm Support    
Multiple Database Support        
Shared Hosting Optimization        
Community
Professional Plugin Ecosystem        
Professional Designer Ecosystem        
Support Forums        
Licensing
License Open Source   $$$ $$$ licensed under an enterprise-friendly BSD/MIT open source license
Source Code        
Pricing
Price FREE FREE $40,000 (Not Released)  

Please note that this blog was influenced by other recent blogs by Bil Simser and Richard Dudley ( whom I wish to thank for sharing their objective opinions ).

Tags:

9 comment(s) so far...

Re: Feature Matrix Showdown

One thing that is not immediately clear from the matrix is the ease with which you can redistribute and install DotNetNuke extensions: whether it is a module, a skin or a language pack. To really see the power in the DNN implementation take a look at some of the trials that a Sharepoint developer goes through: http://weblogs.asp.net/bsimser/archive/2006/07/04/Automating-your-Web-Part-builds-_2800_and-distribution_2900_-with-WPPackager-and-NAnt.aspx. The unstated part of Bill Simser's posting is that the minute you have to start modifying policy files or running MSIs, you have lost everyone who is running in a shared hosting environment.

By jbrinkman on   7/5/2006

Re: Feature Matrix Showdown

As an Open Source product DNN underscores an observation from mainframe days - given the opportunity, customers will often write the best or most appropriate software for any platform. Then as now business developers don't require the equivalent of a combine harvester when all they are wanting to do is clean carpets. The extensible framework of DNN offers the most pragmatic business solution I've seen since Microsoft dropped the essential business friendliness of visual basic. As Antoine de Saint-Exupery eloquently put it, "Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away."

By magnetron on   7/14/2007

Re: Feature Matrix Showdown

I guess that we can include in DNN advantages - both Windows XP and Windows server 2003 installations, but Sharepoint 2007 can be installed only to Windows Server 2003. Hardware requirements is not so great.
Due to Sharepoint 2007 - it also has page templates now ( but not with content). Office 2007 great support ( lists, Excel and Infopath support) is also advantage. But hardware requirements are more than for DNN.

By AlexNightingale on   7/25/2007

Re: Feature Matrix Showdown

Hi Shaun,

You forgot the Built-In Scheduler.

By adnanshussain on   7/14/2007

Re: Feature Matrix Showdown

Hi Shawn, Shaun your matrix has a very BIG error or the licensing/cost has changed since you created this matrix. I was told by Microsoft yesterday that the licensing for WSS follows the server’s licensing, which means the only thing you have to purchase to expose the server and hence WSS to internet and an unlimited number of users is to purchase the “external connector” which costs about $2,000 NOT $40,000. The $40K your quoting refers to MOSS.

I have a client, one that I am sure the DNN community would find beneficial to its install base, that had originally planned to use DNN for a new project, but now is considering SharePoint, in part because it is not as expensive as originally thought. Can you please communicate how you came to the conclusion that WSS is $40K when actually it is free with W2003S and only an additional $2K to expose to the web?

Thanks

By jahall4 on   12/6/2008

Re: Feature Matrix Showdown

I've seen some good reviews on other sites that date back to 2006. This one is pretty fair based on that time frame as well. Any updates coming now that we are into the clear [or not so clear] share point plan and cambrian plans?

Thanks much

By tcgx_wsmith on   12/6/2008

Re: Feature Matrix Showdown

Is there a chance please that this matrix could be updated to compare the latest versions?

By Jeff Parker on   12/6/2008

Re: Feature Matrix Showdown

Hi Shaun,

I will appreciate if you can update this metrics and re-post this blog entry. I know that DNN has gone through so many updates since 2006 to the current version and hopefully the 5.0 version that will be comming up soon. I will really appreciate if a new comparison is available from you that will help me make the future decisons and also to showcase the advance features of DNN in comparison to sharepoint.

Also please post a link to the new post in this post as this post comes up in the google search.

Thanks.

By wasay on   12/6/2008

Re: Feature Matrix Showdown

I think the following Blog has a good description of why the current version of SharePoint still does not meet the needs of the SMB market from a licensing perspective:

www.cmswire.com/cms/web-cms/sharepoint-web-content-management-licensing-was-botched-002284.php

The "Internet Connector" license price is out of reach for most small business owners.

By Shaun Walker on   12/6/2008

Sponsors

DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation

Hosted by MaximumASP