Stonefield Query for Act!

Stonefield Query logo

News Flash: Version 4.0 of Stonefield Query for Act! is now available! Among the new features are:

  • Output to Pivot Table (MS Excel) -- A new file output type is available: Microsoft Excel PivotTable. This type, which is available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
  • Customize the joins (relationships) -- You can now customize the relationships between tables in a report without having to edit the SQL statement for the report. To do this, click the Advanced button in Step 2 of the report wizards to bring up the Customize dialog and in step 2, you’ll see the new join editor. Note that this only appears if there is more than one table in the report (i.e. a join is needed). This should mostly eliminate the need to customize the SQL statement for a report.

Click here for a complete list of the new features.


Stonefield Query for Act!® is a user-friendly data mining, query, and report writing tool designed specifically for Act!. You no longer need to call the IT specialist every time you need a report. Now your sales people, administrative staff, and management can create their own reports in minutes after only an hour of free training. Stonefield Query for Act! can handle virtually all of your reporting needs.

Stonefield Query has a simple "wizard" interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and select where the output should go (printer, disk file, spreadsheet, screen preview, etc.).

In addition to running pre-defined reports, you can create your own "quick" reports in just minutes. Simply select which fields to report on from the list of available fields (full English descriptions rather than cryptic names and symbols), and you're done! You don't have to know complex stuff like join conditions; Stonefield Query takes care of that for you.

Sweet deal! Stonefield Query comes with over 160 pre-built reports that you can use as is (including printing) or modify to your liking. These reports alone are worth the price of the product.

Features for Act! users:

  • More than 160 pre-defined reports are available. These reports alone are worth the price of Stonefield Query!
  • Use Stonefield Query to create new and update existing Act! Groups using any filter criteria.
  • Stonefield Query provides access to all user-defined fields. All fields appear with the caption assigned by the user.
  • Multi-Database Support: A single report can be run against each of your Act! databases without making changes to the report.
  • Data can be extracted from anywhere in Act!, including Activites, Sales/Opportunities and Notes/History.
  • Stonefield Query for Act! can report on information in QuoteWerks, a quoting system that integrates seamlessly with Act!.

Features:

  • Simple "wizard" interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and select where the output should go (printer, text file, spreadsheet, screen preview, etc.).
  • Handles complex join conditions between tables automatically.
  • A new Cross Tabulation Wizard allows you to create cross-tab reports with just a few mouse clicks.
  • You can now create a filter that compares one field to another field in the same table (using the More button in the Filter Condition dialog).
  • When you create a report, you can specify whether other users can access the sort or filter pages for each one. You can even define reports that are only accessible to specific users.
  • Click on the "values" button to get a list of all possible values for any field.
  • Control font, color, alignment, heading, and column width for each field. Group on any field with a mouse click.
  • The Advanced Report Designer allows you to completely control the look of your reports. Move fields around, add lines, boxes, and shading, include graphics such as company logos, define calculated fields, etc.
  • Output to Microsoft Excel, HTML, Microsoft Word, comma-delimited, or other types of files.
  • Knows your data. You don't have to know how your data is stored or how tables are joined (you don't even have to know what a 'join' is).
  • Import reports so you can use report layouts designed by other users or consultants.
  • Export reports so you can share report layouts with other users.
  • Display 'real' table and field names so it's easier to locate the table or field you want if you're familiar with these names.
  • Context-sensitive help provides easy-to-follow instructions for every task.

Stonefield Systems Group Inc. logo

ADD TO CART



View Shopping Cart

Report Designer:
$938/1 User or $44.95/month

Report Viewer:
$281/1 User or $22.50/month

FREE TRIAL

I have to report that I've thrown over my loyalty to Stonefield Query. The simplicity and depth of the program make it easy for me to recommend ... in my examination, they've thought of nearly everything an Act! user would ever need.
--Doug Wolf, Act! Certified Consultant and author of Crystal Reports for Dummies

Compatible with:

  • Act! 3 and Newer

Technical Support

PURCHASE OPTIONS

Close Purchase Options

IMPORTANT: This product must be registered with the manufacturer within 30 days of purchase. Complete instructions are provided in the software. No product returns will be accepted after registration. Free trial versions are available for download.

Please note: One year of required software maintenance is included in the prices below. Software Maintenance includes: product updates, version upgrades, and unlimited e-mail support. 30 minutes of free telephone support comes with each license. Additional telephone support is available for purchase.

Report Designer licenses allow the user to create new reports, edit existing reports and run reports. Report Viewer (formerly Runtime) licenses allow users to run existing reports with report filter, sorting and export changes but they cannot create new or edit reports.

The 'right to use' for the bundled Report Viewer licenses means that as long as the customer keeps their software maintenance current for the Report Designer licenses in the future they will continue to receive the use of the Report Viewer licenses at no charge (including no software maintenance fees on the Report Viewer licenses). Report Viewer licenses can also be purchased based on the pricing below.

Existing Stonefield Query customers can purchase additional Report Designer licenses and receive the 'right to use' the Report Viewer licenses at the reduced 'Additional License' price below.

*If you are purchasing multiple copies, click the 'Buy Now' button below and at the next screen, change the quantity and press the 'Update Quantities' button. Your discount will show up in resulting screen.

All products have a 30-Day Money-Back Guarantee unless otherwise noted. All returned products are subject to a 10% restocking fee.

Stonefield Query for Act!

   

  Version

Users

Price

 

 
   

 Report Designer

1

$938.00

Buy Now

 
   

    Additional Licenses

1

$234.00

Buy Now

 
   

 Report Viewer

1

$281.00

Buy Now

 
             
   

 Monthly Report Designer

1

$44.95 / month

Buy Now

 
   

    Additional licenses

1

$10.00 / month

Buy Now

 
   

 Monthly Report Viewer

1

$22.50 / month

Buy Now

 
   

    Additional licenses

1

$10.00 / month

Buy Now

 

Close Purchase Options

New Stonefield Query 4.0 Features

Close

New Stonefield Query 3.2 Features


Other Stonefield Query features

Close

Close