Does Stonefield Query work with Windows Terminal Server or Citrix?

Yes, it works the same on Windows Terminal Server or Citrix as it does a normal network server, with the same features and licensing. The only exception is that reports cannot be scheduled on a Citrix server since Citrix doesn't support the Windows Task Scheduler API.

Can you create formulas?

Yes, you can create formulas for a report using Formula Editor.

Can you suppress sections of the report?

Stonefield Query has a "summary report" feature that suppresses all detailed fields that have not been grouped. Also, you can use the Advanced Report Designer to change anything you wish in headers, footers, etc.

Can you parse string fields, such as looking for data in the first two positions of a field?

You can create a filter that uses the "contains" or "begins with" operator.

Can I include columns in a Microsoft Excel spreadsheet in a report?

You can add any data source, including a Microsoft Excel spreadsheet, to Stonefield Query using the Add Data Source function in the Tools menu.

Is there access to the optional fields?

Yes, we actually take it one step further and display the "name" of the optional field that the end user has given it in the setup of Sage 300 (so the user will pick "Ship Zone" as the field name, not TextOpfl2). When the data is listed on the report, the user will see the "value" from the optional table if there is one linked (i.e. "Blue Zone" instead of "BLU"). See the Reporting on Optional Fields topic for more details.