...

You also need to grant View privileges related to the base objects your reporting definitions use. For example you need "View Programs" to create and use an "In Program" Cohort Query

Building Reports

Understanding the Basic Terminology

...

A filter is also built from a Cohort Definition. A filter narrows the results of every question in the indicator report. For instance, applying a filter using the Cohort Definition "Not Exited from Care", makes sure that no patient ends up in a report that is no longer a patient of the clinic.

...

Types of Reports

...

Cohort Query Types By Domain

...