InetSoft Product Information: SQL Reporting Tools


InetSoft formed in 1996 to deliver SQL reporting tools that would be more productive for database analysts to use compared to the traditional methods of SQL programming. Soon thereafter the company's first reporting tool began winning awards from developers - starting an 8-year streak of Readers Choice awards from the Java Developer Journal for best reporting tool.

Today InetSoft's Style Intelligence™ platform continues to lead among SQL reporting tools for:

  • its strengths in being able to produce pixel-perfect output to meet the most demanding of formatting requirements
  • for the time it saves versus hand-coding SQL thanks to a drag and drop interface
  • without sacrificing any of the control and flexibility that other GUI tools lack
dashboard built  with InetSoft's SQL reporting tool
demo icon
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

Features of InetSoft's SQL Reporting Tool

Data Access:

  • Connectivity to Relational databases (JDBC), Multidimensional databases, XML, SOAP, Java beans (POJO), EJB beans, flat files, CORBA objects
  • Custom data access adapter
  • Data model, query and data blocks
  • Data mashup across multi source data objects
  • Security control on data cell level
  • ERWin data model importer

Ad Hoc Reporting:

  • Intuitive, 100% Web, zero client access from portal
  • Wizard guided report creation and free form editing
  • Customized prototype for new wizard
  • Aggregate, grouping, filtering
  • Report layout and presentation element library
  • Security restrictions automatically applied

Embed and Integration:

  • Single sign-on and out-of-box LDAP integration
  • Web service and SOAP architecture
  • CSS driven presentation customization
  • Componentized portal
  • JSP tag library for presentation
  • IIS and MS Share Point integration
  • Java API for data and report manipulation

Business Logic Embedding:

  • Report, page, or element level scripting using JavaScript
  • Highlighting on background, foreground, font
  • Conditional control on element visibility, page break
  • On-export and on-print report control
  • Dynamic drilldown to report and URL

Enterprise Reporting Environment:

  • Security control on data cell, report, folder
  • Security by individual, role, group, and functional module
  • Schedule with customizable conditions and actions
  • Archiving and versioning
  • Audit, access, and error logs
  • HTTPS support and encryption on PDF outputs
  • User disk quota control
  • Team development environment

Production Report Design:

  • Powerful WYSIWYG report designer
  • Word processor-like and HTML-like layout
  • Rich presentation element library
  • Dynamic expanding table, formula table, and super crosstab
  • Free positioning field based section(band)
  • Charting library with over 30 different types
  • Reusable meta template and report beans
  • Sub-report nesting
  • Advanced presentation - TOC, maps, images
  • Localization and internationalization to any language

Interactive Report Viewing:

  • Zero client, security controlled web portal
  • In-report sorting, filtering, hide/unhide
  • Drilldown from any report element to another report or URL
  • Parameters in cascade and staging mode
  • Summary/detail toggling display
  • Report element context menu
  • Real-time viewing or queued reports
  • Dropdown list, text fields and other form controls
  • Export to Excel, PowerPoint, PDF, RTF-Word, CSV, PostScript, Text, and SVG
  • Email, server-based printing, and client-based printing
  • Archived report with in-report exploration

High Performance and Scalability:

  • Data access connection pools
  • Data streaming and page streaming
  • Configurable data and report page cache
  • Clustered reporting service
  • Concurrent report threading control
  • Bursting and scheduled report
  • Resource management on file system and database
dashboard demo
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.