.
   

iQ-Sql

SQL Query and Reporting tool
Works with: SQL Anywhere, SQL Server, Firdbird and PostGreSQL

iQ-SQL is an SQL Query tool for SQL Anywhere, SQL Server, Firebird and PostGreSQL. It is a reporting and data mining tool which adds extensive functionality to standard SQL queries including:

  • Sub totals and Grand Totals
  • Domain Checking
  • Highlighting
  • Column Formatting
  • Prompt fields and Parameter fields.
  • Exporting and Graphing of Data
  • Database/Field browser
  • Optional Wizard
  • Print/PDF Query results
  • Menu to store SQL queries.
  • and too much include here

 

Example:

SELECT Invoice,OpenAmount,Balance
FROM INVOICES
SUBTOTAL OPENAMOUNT,BALANCE
HIGHLIGHT 3 WHERE BALANCE > 1000
SETREPORTFOOTER 'My Report'

 

 

 

 

 

 

SQL Extension Syntax:

[ SUBTOTAL {column | AVG(column) | COUNT(column) | ACOUNT(column) | WAVG(columnlist) ,... }[ON break-column | EXISTS(column) | MONTH(column) | YEAR(column) ,... ] [HIDEDETAIL] [HIDEGRANDTOTAL]

[ PIVOTRESULTSET [WITHTOTALS] ]

[ DOMAINCHECK ON email-column [DELETE | KEEP] ]

[ PAGEBREAK ON [ break-column ,... ]

[ [ HIGHLIGHT column [TO column] WHERE valid evaluate statement [BGCOLOR=nnnnnnn] [IGNORETOTALS] ] repeated as needed ]

[ [ FORMATCOLUMN column [TO column],ATTRIBUTE=VALUE ] repeated as needed ]

[ SETREPORTHEADER 'report header string text 1-255 characters' ]
[ SETREPORTFILTER 'report filter override string text 1-255 characters' ]
[ SETREPORTFOOTER 'report footer string text 1-255 characters' ]
[ NOREPORTFILTER ]

[ FORCEGROUPHEADER {YES | NO} ]
[ NODATAGRIDPREVIEW ]
[ NOCURRENCYPICTURE ]

[ EXPORT {AS FILE | AS GRAPH} USING {‘name of .qwe file’ | ‘ValidChartType’} [LabelFormat=valid label format] ]

The only limitation is that it will select up to 32 columns at once.

Note - This product has reached it end-of-life. It is no longer supported. You are welcome to download and use it but there is no support for it and there will be no future changes/fixes/enhancements

Download iQ-SQL (Version 2.51 - July 19, 2013)

Registered price: $99.00 per developer/user - (You may download and install as Full Trial Version)

(Payments will be received through Paypal - contact me for instructions)

 

Keywords: Query tool and Report Tool for SQL Server, SQL Anywhere, PosGreSQL and Firebird.
 
 
  (c), Robert Paresi - All Rights Reserved