Skip to main content

Error: You have reached the maximum number of arguments allowed for creating the report

Overview

When specifying filters using the Report Wizard, you may see a message informing you that you cannot add any more filters.

maxfilters.png

Complete text of error message is:

You have reached the maximum number of arguments allowed for creating the report.

Cause

Under normal conditions, a Jet function is limited to a maximum of 10 filter arguments.  When sorting or accessing a data source and/or a company other than those that are defined by default, these each use one of the available filter arguments within the function.

Resolution

  1. Your first option would be to examine the filters you are using and determine if there are any that are not required for your report.

  2. An alternative is to complete the Report Wizard with the filter arguments you have already defined, and - once complete - modify the resulting report as described in Using More Than 10 Filters In An NL() Function.

Was this article helpful?

We're sorry to hear that.