Overview

Query Tool allows novice and experienced users to directly access corporate data resources for real-time data exploration. Using only a Web browser, users can view published queries, saving and modifying them as required to meet their information needs.

Query Tool is very easy-to-use and allows query users to run and modify existing queries, design new ones, and optionally publish queries back to the portal for future use.

Query Tool is easy to support and was specifically designed for Web deployments. The client software is HTML-only, meaning anyone with a browser—including extranet users like customers, suppliers, and partners—can create and execute queries. IT never has to install, configure, or support custom software on client desktops, and users never have to download plug-ins or Java applets

Features

• General
  Previously defined queries can be executed, viewed and/or copied
  Reports can be easily viewed and modified realtime using a browser
  
• Fields to be Displayed
  Fields are simply chosen from a list of all the fields that are available
  
• Selection Criteria
  Selection criteria can involve fields that either displayed or not displayed
  Operators include: not equal to, <, =<, >, =>, contains, begins with, ends with, between
  
• Sort Order
  Fields are simply chosen from a list of all the fields that are available
  
• Users
  Users are chosen from a list as to who may view/run/modify this query
  
• Page Setup
  Margins can be defined: top, bottom, left and right
  
• Page Headers
  6 individual page headers can be defined
  Options include: font, font size, image, text, borders, bold, italic and underline
  
• Column Setup
  Column headings can be defined
  Column headings options: font, font size, border, bold, italic, underline, alignment, back color
  Column details options: font, font size, border, bold, italic, underline, alignment, back color
  Other options include: column total, column average, suppress duplicates, offset, line break, width size, width percentage
  
• Control Breaks
  Breaks (or sub totals) can be setup on any field displayed or not displayed
  Break headings can be defined and options include: font, font size, border, bold, italic, underline, alignment, back color
  Other options include: page break, suppress count, suppress detail, suppress repeating detail, space before break space after break
  
• Scheduling
  This is a powerful function allows predefined queries to be scheduled to run and the output to be emailed to a group of users
  Output types include: HTML, excel spreadsheet, Word document
  Active: yes or no
  Schedule options: day of the week, day of the month
  Non business day processing includes: do not process, process day before, process day after
  A schedule may have an effective start date and end date