Amalgamated Pest Control

“We just got to a stage where our old system was holding us back. The software was not keeping up with our level of growth and our GST needs.”

Read the full story

More with the Power of 3

Read customer stories
Find a partner

Query Tools & SQL

You’ve always got the right answer! Often a question is asked that cannot be answered with a financial or operational report, so Greentree caters to this requirement providing very capable options for ad-hoc enquiry or analysis.
 

DOWNLOAD PDF

KEY BENEFITS

  • 360 Degree view of information
  • Unlimited data drill down analysis
  • Wide Web Accessibility
  • Live links to Microsoft Office Excel®
  • Extensive library of reports
  • Flexible user defined reports and graphs
  • Automated report scheduling
  • Email and export reports and documents
  • Powerful Query tools
  • Business Intelligence powered by QlikView
  • Publish information to Microsoft SQL®

Explorer

Greentree Explorer is designed as a non technical query builder that allows you to build flexible searches, save these for future use, and retrieve and drill down into the data matching the query. This information can be launched in Microsoft Office Excel. Using the built in wizard, queries can also generate Greentree reports for future reuse or modification in the Report Designer.

Inspector

Inspector is specifically designed to aid the more technical user in examining Greentree’s database and analysing information down to the lowest levels per item or transaction and includes capabilities for defining queries to pinpoint the required data for analysis.

Greentree SQL

Greentree provides a host of inbuilt reporting and analysis tools plus open access for other reporting systems, e.g. Microsoft® Reporting Services. Greentree SQL offers a number of methods to support open access from ODBC through to populating a data warehouse in Microsoft SQL Server® in real time. This allows customers to centralise data from not only their Greentree software but also from other associated systems into a single SQL Server repository.