+61 (0)8 9345 0522ABN: 21 008 930 989ERP for Mining | Oil & Gas | Exploration | Drilling | Engineering | Construction

Data Query

Data Query

This module is an easy to use custom report writer that enables the user to access any of the files in the system and produce special reports. You may mix together data files from different modules and pick out data for some very special reports. There are comprehensive criteria selection, calculation, edit and presentation commands which provide for even the most stringent reporting needs.

The Data Query module is an easy to use custom report writer. Even a novice can create complex reports quickly through the use of English commands, logical procedures and choices from Multi-level window menus.

Pre-defined reports or quickly designed reports provide you with quick answers to questions and provide answers to those “What if “ scenarios

You can arrange Classic data into columnar lists, both detailed and summary for extraction to MS-Excel or for preview or print directly to a printer. Mathematical functions can be built in to produce calculated fields. Selection Criteria ensure only the information you want is included.

The Data Query System

PRE-WRITTEN REPORTS INCLUDE

  • Catalogue of stock
  • Days since last sale 
  • Lines ordered & received  
  • Maximum & Minimum quantities for all stock items
  • Overdue line items  
  • Purchase Order register
  • Purchases received & ordered
  • Stock Usage Reports – Various
  • Supplier list 

Of course, the Data Query module operates in “read only” mode. Data Query only looks at the information. Any temporary fields you create within a model will exist only within the model, they are not added into your Classic data files.

To use Data Query you select the databases from which you want to extract data. (A list of the Databases available within Classic as well as a description of the fields within the databases is provided with the Data Query manual)

How you proceed from that point in the design of your report and the selection, sorting and grouping of your data is up to you. The biggest limitation you will face is your imagination.

You can save queries or models you have developed so that they can be run at a later date against updated databases.

Querying data has never been so easy.To use this module you will need to select the databases from which you wish to extract data. Classic will provide you with a list of the databases available as well as a description of the fields within the databases.

Data Query formats can be customized into columnar lists. Output can then be sorted & summarized according to the User needs.

Full professional reporting is  available from Classic’s standard reports, as well as the unlimited capabilities provided by this module. You may design and save any query/report you may require from the Classic data files and join databases together if required.

Structured Query Language (SQL) is  available providing the User with the ability to program more complex models  and   reports.

Querying data has never been so easy.To use this module you will need to select the databases from which you wish to extract data. Classic will provide you with a list of the databases available as well as a description of the fields within the databases.

This module is highly interactive with the User providing unlimited reporting capabilities with minimal programming experience required.

Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.