Stonefield Query is licensed on a per-user basis. That means each user who wants to create and/or run reports in Stonefield Query requires a license. Here's how licensing works:

  • Until Stonefield Query has been activated, it runs in "unactivated" mode. The user is prompted each time they run Stonefield Query if they want to activate it. If they choose to do so, the License Manager appears. They click the Add button to add a license. The registration number that appears is based on several factors, one of which is information about the system where Stonefield Query is installed (not necessarily the workstation it's running on, but the system where the program resides). They enter the serial number they were given when they purchased Stonefield Query and click Online to activate it. The activation code that appears is also based on several factors, including the registration number, serial number, and number of licenses purchased. Licensing information is stored in a file named SFQuery.lic in the Data subdirectory of the program folder. For an unlimited license file, the file is named Unlimited.lic.

  • The same holds true for Stonefield Query Studio; the only difference is the name of the license file, SQConfig.lic.

  • Users in the Administrators user group (such as the ADMIN user) are the only ones who have access to the Maintain Users and Groups dialog in Stonefield Query. In that dialog, an administrative user can only define as many user names as there are licenses. They can also specify which users use which licenses if more than one type of license is installed. For example, if there are two Ultimate and five Basic licenses, they can define up to two Ultimate users and five Basic users.

  • When a user logs in, Stonefield Query does two checks. The first is how many users are currently running Stonefield Query. If all licenses are currently in use (for example, five users are currently in Stonefield Query and there are five licenses in total), the user is informed of this and Stonefield Query terminates. The second check is whether another user is logged in with the same user name. If so, the user is informed of this and Stonefield Query terminates. So, Stonefield Query licensing is a combination of named users (they can only define as many user names as there are licenses) and concurrent use (only as many users as there are licenses can be logged in at the same time).

License types

There are four types of licenses:

  • Basic: Basic users cannot create or edit reports and have certain other limitations.

  • Pro: Pro users can create and edit some report types and can create formulas.

  • Premium: Premium users can create and edit more report types than Pro and also have access to the Advanced Report Designer and Template Editor.

  • Ultimate: this is a replacement for the Report Designer license in earlier versions (existing Report Designer licenses now appear as "Ultimate"). Ultimate users have full functionality.

Earlier versions of Stonefield Query had two types of licenses: Report Designer and Report Viewer. Report Designer licenses have been renamed to Ultimate. Report Viewer licenses are mostly the same as Basic but have a few more abilities. If a user has a Report Viewer license, it appears as a Report Viewer license.

The following table shows the features available to each type of license:

FeatureBasicProPremiumUltimate
Run any type of reportXXXX
Import reports created by othersXXXX
Prompt for filter values ("ask at runtime")XXXX
Output reports to file (PDF, Excel, etc.)XXXX
Email reportsXXXX
Drill down from summary to detail reportsXXXX
Support multiple databases (if Allow multiple data sources is True)XXXX
Create/edit row and column ("quick") reports XXX
Create/edit cross-tabulation reports XXX
Create/edit labels XXX
Create/edit batch reports XXX
Create formulas XXX
Create drill down reports XXX
Create/edit charts  XX
Add charts to quick and cross-tab reports  XX
Edit report layout ("Advanced Report Designer")  XX
Create/edit templates  XX
Create/edit gauges   X
Create/edit dashboards   X
Create subreports   X
Report on multiple databases in same report (if Allow queries on multiple data sources is True)   X
Schedule reports   X
Usage reporting   X
Number of free support tickets per year02410

There is one other type of license: an Unlimited Report Viewer license allows an unlimited number of users to run reports but not create a new report or copy or edit an existing report. This license allows you to distribute Report Viewer licenses (similar to Basic licenses) to as many clients at as many sites as you wish without paying individual license fees.

In the case of the usual four license types, a license file named SFQuery.lic is created when the user activates the application. For an unlimited license, you install a file named Unlimited.lic you were provided by Stonefield Software in the Data subdirectory of the Stonefield Query program folder on the user's system (this is normally done as part of the installation).

Managing licenses

The License Manager in the Tools menu, which is only available for users in the Administrators user group, can be used to add or remove Stonefield Query licenses or see the currently installed licenses.

Licensing reports

You can license certain reports so only authorized users can import them. This allows you to protect reports that you charge customers for so only those customers who've paid for the report can use it.


© Stonefield Software Inc., 2018 • Updated: 03/08/18
Comment or report problem with topic