New Stonefield Query for Sage 300 Version 5.2 Released

CHICAGO - Sept. 22, 2015 - PRLog -- Stonefield Software is please to announce the release of version 5.2 of Stonefield Query for Sage 300. There are several new features in this latest release of our award winning software.

Report Designer

There are two new settings on the Grouping page of the Properties dialog for fields in step 2 of the Quick Report Wizard: Retrieve all records and Number of records per group. Turn off Retrieve all records and enter a value for Number of records per group to limit the number of records per group. You can combine this with sorting on one of the fields in the detail for the group to see the oldest or newest record. For example, suppose you want to see only the most recent activity for a customer.

- A new type of filter operator is available for date fields: Is. When you choose this operator, you can select a date type to compare the field to, such as This Week, Last Year, or This Month to Date, from a drop-down list.
- Dashboards can now include all types of reports, not just charts and gauges. Note, however, that the dashboard window doesn't scroll so it's really only appropriate for short, informative reports.
- Step 2 of the report wizards now shows information about the field under the mouse pointer in a "balloon" tip. For the Available fields list, the balloon shows any comments about the field. For the Selected fields list in a quick report or label, the balloon shows how the field is formatted in the report: whether it's grouped or summed, what numeric or date format is used, and so on. This allows you to see at a glance information about the field without having to click the Properties button.
- You can now select more than one grouping field for a grouping formula. This is necessary for a formula that, for example, show sales for a certain date range by customer and product.
- A new type of output is available: Microsoft Excel - Data Only (Fast). This is similar to Microsoft Excel - Data Only but is faster and doesn't require that Excel is installed on the system. This format works better that Microsoft Excel - Data Only with scheduled reports because Excel doesn't always work correctly when run from a scheduled task.
- You can now specify whether category and series fields are sorted in ascending or descending order in a chart.
- You can now specify a background color for fields in a report in the Properties dialog. Sample text shows what the colors of the field will look like in the report. You can also revert to the default color for the field by turning on the new Use default color setting.
- You can now export and email a report layout to someone in one step: right-click the report in the Reports Explorer and choose Email Report File, enter their email address, and click Send.
- The Filter page in the Reports Explorer and report wizards has a new setting: Warning if no filter when report is run. This used to be a global option in the Options dialog but is now available on a report-by-report basis.
- The Options dialog no longer has a Date Format setting; the application now always uses the date format specified in the Windows Control Panel.
If no output settings are specified when a report is run from the command line, the saved output settings for the report are used if there are any.
- If an advanced layout report has any images, such as a company logo, those images are included in the SFX file for the report. If you export the report and send the SFX file to someone but forget to send them the image files used by the report, the Import process they use to add the report to their reports list creates a new folder called Images and puts the images imbedded in the SFX file there. The benefit of this is that you no longer get an error about a missing image in this case.
- Some settings in the Options dialog now affect all users on a network: Create and display report snapshots, Send summary queries to database engine, Week starts on, and Year starts in. These settings are saved in Data.ini in the Data subdirectory of the program folder rather than in the Windows Registry where other settings are saved.
- The Show totals in group headers setting for quick reports is now available for advanced layout reports.
- The positions of the Advanced Layout, Chart, and Edit buttons in step 5 of the Quick Report and Cross-Tab Wizards was changed a little to accommodate other controls.
- The Alignment setting in the Properties dialogs for fields now displays icons for left, right, and center alignment.
- The new sample report Inventory Valuation in the Sample Report\IC Reports folder shows the inventory valuation by item as of a specific date without regard to location.

Get the full function demo today and try it with your Data. Stonefield Query Makes Reporting Simple.

www.stonefieldsoftware.com

About Stonefield Software

Stonefield Software Inc., the makers of the award-winning Stonefield Query, has been developing Business Intelligence database reporting solutions since 1991.Stonefield has partnered with over 800 OEM and ISV partners to deliver BI reporting solutions to more than 225,000 users in over 65 countries globally to date. Our customers span all sectors and industries from public to private, military to non-profits, Fortune 500 to Small and Medium Enterprises (SME). Stonefield Query has been designed and developed with the end-user in mind.