The Act! Advanced Query option allows the creation of complicated queries against the Act! database. These advanced queries can be imported into Reporting4Act!, where they can be used as the starting point for new reports. To import one of these queries, select the Import Act! Advanced Query item from Reporting4Act!'s File menu, and then select the query to import. Reporting4Act! will then create a new report, and use the Act! advanced query as the report filter. Once this import is done, the report and its filter behave like any other Reporting4Act! report; they can be run and modified as usual.

The screenshots below show a sample advanced query in Act!, and the filter created when it is imported into Reporting4Act!.