Welcome to Smoke Ranch Software

Providers of Commercial Modules and Custom Development for the DotNetNuke Platform.  
Links  
DotNetNuke

Buy Smoke Ranch Modules at Snowcovered.com
 
SQL Deluxe Module for DotNetNuke 4x
Write interactive reports, run and save SQL scripts, view query results with automatic sorting and paging, and more with this powerful module.

Click To Purchase On Snowcovered
Features
Designed for DNN 4x and SQL Server 2000/2005.
Save and manage your SQL scripts.
Create interactive, parameterized reports – allow the user to enter data which will be dynamically inserted as parameters to your SQL queries.
Automatic sorting and paging.
Tokens – insert tokens into your SQL code to dynamically represent common values, such as the current User ID or the current Portal ID. These tokens are automatically replaced with the correct values when the SQL is executed.
Connect to multiple databases. The module allows you to define multiple connections, and then specify the desired connection to use for a given report, or when running ad-hoc queries.
Flexible security features -- rely on the module settings or specify which Roles are allowed to view each report.
Protection against SQL injection attacks -- interactive reports use parameterized queries, rather than concatenation of SQL, preventing attacks from malicious users.
Optional integration with the Smoke Ranch Ad Banner Manager v4.5 allows targeted ads to be served based on user-entered data supplied to an interactive report.
Available with full C# source code!

Documentation
The User Manual is available in PDF format.

Click Here to View the User Manual
Download the user manual
 
Need Help?  
Have a need for custom module development? Are you looking for a module but can't find one that does what you need? Contact us for details on custom modules.
Screenshots

Viewing an Interactive Report

Executing ad hoc SQL queries

Saving a query as a report

Ad Banner Manager for DNN4x | Media Player for DNN 3x and DNN 4x | Simple User Export for DNN 3x | SQL Deluxe with Interactive Reports | Content Rotator for DotNetNuke 4x
Copyright 2006-2008 by Smoke Ranch Software