The ReportGrid module for DNN 4.x and DNN 5.x, allow you to easily create reports of your data using a simple query or a stored procedure. Supports Master/Details visualization, export of data to Excel & XML and much more......

 Create your reports from any database!!

Features: Tabular reports using the new ASP.NET 2.0 GridView Detail reports using the new ASP.NET 2.0 DetailsView Paging and Sorting features Configurable query Ability to connect to any database using a Connection String from the web.config Ability to export data to Microsoft Excel (XP/2003) Ability to export data to XML Easy installation and uninstallation Test connections and queries before publish your reports Security enhanced - Only host users can compose reports Security enhanced - Malicious query filtering (NEW) Support for stored procedures (NEW) Support FreeText, Calendar and DropDownList user parameters! (NEW) Implements DotNetNuke advanced features (ISearchable, IPortable) (NEW) Support w/AJAX with DNN 4.5.x (NEW) Master/Details visualization using multi-instance of ReportGrid, IMC enabled (NEW) Special variables support (@PortalID, @ModuleID, @TabID, @UserID, @Year, @Month, @Day, @Today)

Export to Excel using XSL trasform Export to XML

Seamless integration with your portal

To install the modules simply use the DNN Interface to upload the new modules.



Tip: You can place the modules under {Root}/Install/Modules and browse to {Root}/Install/Install.aspx?mode=installresources in order to manually load the modules.

Following an example on how to add a connection to an Oracle and to a SQL Server database. Please notice that the first connection is the default connection to the DNN database.

<connectionStrings> <add name="SiteSqlServer" connectionString="Server=.\SQLExpress;Connect Timeout=30;User ID=XXXX;password=XXXX;Database=XXXX;Persist Security Info=True;" providerName="System.Data.SqlClient"/> <add name="Oracle" connectionString="Provider=OraOLEDB.Oracle.1;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX" providerName="System.Data.OleDb"/> <add name="SQLServer" connectionString="Server=.\SQLExpress;Connect Timeout=30;User ID=XXXX;password=XXXX;Database=XXXX;Persist Security Info=True;" providerName="System.Data.SqlClient"/> </connectionStrings>

Please note that each entry must contain the providerName attribute in order to correctly work with ReportGrid & ReportChart.

Please also visit http://www.connectionstrings.com in order to find more databases not listed here.

You're now ready to use ReportGrid! Check out the Tutorials section and the Live Demo for more information on its usage.