Version 7.0

There are lots of new features in this release.

  • Stonefield Query for Act! is now known as Reporting4Act! - Powered by Stonefield Query.

  • Reporting4Act! is now compatible with Act! v20.1.

  • Reporting4Act! supports the new Custom Tables feature in Act! v20.1. Custom tables defined in a database will appear for reporting in Reporting4Act! alongside the standard Act! tables.

  • Multiple license types are now available. This allows you to decide what set of features you would like to have.

  • You can now evenly spread the columns across the page in a quick report by turning on the Auto-fit to Page setting. This setting adds extra space between the columns so the fields take up the entire width of the page.

  • You can now sort a cross-tab report by a data field. This can be used to, for example, show customer sales by country and product with the largest customers (by sales) at the top and smallest at the bottom.

  • You can now specify the number of columns to display in a dashboard. If the total number of cells (rows multiplied by columns) is less than the number of reports, the reports are cycled through in sets at the specified interval. For example, if you specify two rows and two columns, only four reports can be displayed at a time, so if the dashboard contains six reports, the first four are displayed, then the next two, then the first four again. The interval is now in seconds rather than minutes. Also, you can now add more than 9 reports to a dashboard.

  • You can now specify the minimum and maximum values for a gauge. The goal value is now optionally shown as a goal marker on the gauge.

  • You can now specify the title settings for the right axis in a chart that has a field plotted on the right axis.

  • Fields containing HTML and rich text (RTF) content can now be displayed as formatted text.

  • The performance of outputting a report with a large number of records (tens of thousands) to Microsoft Excel Data-Only (Fast) was greatly improved (90% faster) and produces smaller XLSX files.

  • You can now format a field to display negative numbers in parentheses rather than with a minus sign (for example, (123.45) instead of -123.45).

  • The Select Values dialog, which appears when you click the Values button in the Filter Condition dialog or the Expression Builder, now has a Search option so you can search for values.

  • The value for a filter condition can now be used in the custom description of the condition.

  • The Preview window has new zoom levels: 1000%, 800%, and 500%.

  • Expression builder buttons are now available for the header and footer of a report and for the subject and message of an email, making it easier to enter expressions for these things.

  • The GetValueForField and GetValueForParameter functions now accept a parameter indicating which value for "is between" and "is one of" conditions is returned.

  • You can no longer schedule a report to output to any Microsoft Excel format other than Microsoft Excel Data Only (Fast) because the other formats require running Excel behind the scenes and Excel cannot be reliably run from a scheduled task as Microsoft themselves admit.