Like me on Facebook Follow me on Twitter Register or    (Why?)
You are here Modules SQLView Pro
Testimonials
SQLView Pro is used on a daily basis by management here. It allows us to very quickly and easily provide a window into our web site statistics for those that need to put together reports. SQLView Pro has made us look like heroes many times. In addition, DNNStuff’s support has been very good when the rare issue has come up.John Slater (Sharp USA)
SQLView Pro DotNetNuke Module

SQLView Pro

SQLView Pro is a DotNetNuke module that converts your data into stunning grids, charts or anything else you can dream up.

How does it help me?

  • Utilize data you already have available and present that information in an attractive interface
  • Unlock the data from other 3rd party modules and display it the way you've always wanted

Content

  • Retrieve data from your DNN database
  • Retrieve data from any external OLEDB compliant database including Microsoft SQL Server, Oracle, Access, Excel, Firebird, MySQL, IBM DB2 and more (Note: OLEDB drivers are not included)
  • Display data in grids or as HTML to produce more unique views

Report Types

  • 4 different report types; Grid, Chart, XSL and Template
  • HTML header and footer areas for report group and each report
  • CSS themes can be applied to report group and each report

Grid Report

  • Dynamic sorting
  • Custom paging including rows per page, numeric or text navigation, pagers top, bottom or both
  • Export to Excel
  • Included skins make your grid look great or you can create your own with standard CSS
  • Hide column headers
  • Drilldown from any column to another report

Fusion Chart Report

  • Display data in a number of chart styles including: Area 2D, Bar 2D, Column 2D, Column 3D, Doughnut 2D, Funnel, Line, Pie 2D, Pie 3D, Stacked Area 2D, Stacked Bar 2D, Stacked Column 2D, Stacked Column 3D, Multi Series Column 2D, Multi Series Column 3D, Multi Series Line 2D, Multi Series Area 2D and Multi Series Bar 2D

XSL Report

  • Specify an xsl file to transform your query data into HTML

Template Report

  • Simpler yet powerful alternative to XSL
  • Specify a template using repeater tokens and data field names to generate any html you wish

Parameters

  • Dynamic parameters such as text boxes, dropdown lists, calendars so users can customize the output
  • Parameter values are passed to your query

DNN Framework Support

  • {databaseOwner} and {objectQualifer} - supports databaseOwner and objectQualifer tokens to ensure your queries are portable across DNN implementations
  • IPortable - supports import and export
  • Tokens - support DNN token replacement in queries and templates so you can query based on UserId, PortalId etc.

Compatibility

  • DNN8 - DNN 8.0.0 and higher
  • DNN7 - DNN 7.0.0 and higher
  • DNN6 - DNN 6.0.3 and higher
  • DNN5 - DNN 5.2.3 and higher
  • DNN4 - DNN 4.6.2 and higher
Privacy StatementTerms Of UseCopyright (c) 2004-2015 DNNStuff
Page generated in 0.0929841 seconds!