SQLView Pro

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
• Display data in grids or as HTML to produce more unique views

Report Types

• 3 different report types; Grid, 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
• Hide column headers
• Drilldown from any column to another report

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

• DNN 4 - DNN 4.5.2 and higher
• DNN 5 - DNN 5.0.0 and higher