Summary

A saved report that used to run now fails and will not show results or export to Excel. This happens when the report has blank field rows. Delete those rows and the report runs again.

Problem

You ran a saved report that worked before, and now it fails and shows no results. You get this error:

DataTables warning: table id = ReportResultsTable - Requested unknown parameter '30' for row 0, column '30'

Cause

One or more rows in the report's Report Fields list have the Object set to Shipment but no field chosen (a blank field row). The results grid asks for a column that has no field behind it, so it shows the 'Requested unknown parameter' warning.

How to check: Open the report's Report Fields list and look for a row that has an Object set but no field selected.

Fix

  1. Open your saved report and edit it.
  2. Go to the Report Fields list and look at each row.
  3. Find any row that has the Object set (for example Shipment) but no field selected.
  4. Remove each blank field row.
  5. Save the report.
  6. Run the report again. It should show results with no warning.
  7. Export to Excel to confirm the export works too.

What you should see

The report runs and shows results with no 'Requested unknown parameter' warning, and it exports to Excel.