Print this page

Why is my user receiving an invalid report error message when filter logic is added to the report?

Knowledge Article Number 000003935
Description

An end user or portal user is able to run a report successfully. When filter logic is added to the report, the running user of the report receives the error message:

"Invalid Report
You cannot run this report because its formulas or filters are invalid or it references fields that are inaccessible to you. Please contact your administrator to update the report. "

Resolution
This occurs because one of the fields used in the Report filter criteria is not visible to the Running User due to Field Level Security.
 
Without the use of filter logic (e.g. (1 AND (2 OR 3) AND 4) in the Report, the filter is simply removed from the report.
When filter logic is added to the report, the report will attempt to evaluate the number of filters indicated in the filter logic.

However, because the running user does not have visibility to one of the fields in the filter criteria, the report will show less filters than indicated in the filter logic. This variance causes the "Invalid Report" error.
 
To troubleshoot, review the field accessibility for all fields used in the filter criteria of the report. Go to Setup | Security Controls | Field Accessibility and navigate to the object in question.
Go through each of the fields in the filter criteria to determine which field is not visible to the User's Profile.
 
This occurs because one of the fields used in the Report filter criteria is not visible to the Running User due to Field Level Security. 
 
Additionally, this may occur for users within the Partner or Customer portal if the amount of filters exceed 10.
These portal only permit access to reports with a maximum of 10 filter criteria even though the Report Builder permits up to 20.

This may also occur if a Platform user has been associated a Profile that lacks the "Create and Customize Reports" permission. Lacking this option prohibits reports from being run with more than 10 filter criteria.




promote demote