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