# How to query a report on cases open for certain Municipality?

**URL:** <https://support.primero.org/forum/t/how-to-query-a-report-on-cases-open-for-certain-municipality/972>\
**Category:** Primero IMS\
**Created:** [August 7, 2025, 1:34pm UTC](https://support.primero.org/forum/t/how-to-query-a-report-on-cases-open-for-certain-municipality/972 "2025-08-07T13:34:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![addossantos](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/a/db5fbb/32.png) [@addossantos](https://support.primero.org/forum/u/addossantos)\
**Post date:** [August 7, 2025, 1:34pm UTC](https://support.primero.org/forum/t/how-to-query-a-report-on-cases-open-for-certain-municipality/972/1 "2025-08-07T13:34:27Z")

</div>

National Manager in Ministry of Social Solidarity wants to query a report on Case Open during a certain month on a certain Municipality (example cases open from January 2025 - July 2025 on 3 Municipality) how to do that? Appreciate your help, Thank you

---

<div class="post-metadata">

**Author:** ![childprotectioninnov](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@childprotectioninnov](https://support.primero.org/forum/u/childprotectioninnov)\
**Post date:** [August 7, 2025, 3:39pm UTC](https://support.primero.org/forum/t/how-to-query-a-report-on-cases-open-for-certain-municipality/972/2 "2025-08-07T15:39:43Z")

</div>

Using the reports functionality you will be able to create a report based on their location, whether it is the location of the case manager or the child. As well as the registration date. To do this, follow this video [https://youtu.be/Jvvn25czYP0?si=EoJDmJRGWpZfIze3](https://youtu.be/Jvvn25czYP0?si=EoJDmJRGWpZfIze3) or the instructions in the User Guide [404 Not Found](https://support.primero.org/assets/books-v2/1WL0OyND1Ookn7pjjo--f59diKDKyhXC5/#h.mny4tzgsxber) and when adding options to the rows or columns you will select the appropriate location. You can also include that you want the registrations to be grouped by Month. Make sure to apply filters that are selecting for Open cases and if consent has not been provided, the report may not display the data. Therefore you can either ensure the cases have consent provided, or can remove the filter. Please note that you may get an error when creating this report, and if you do, this will be addressed in the next release 2.14, scheduled for the end of August.

 ![image](https://support.primero.org/uploads/primero/original/1X/9ad0b46fd8a9ffd0cc1e8ccc6765499eb54f73de.png)

 ![image](https://support.primero.org/uploads/primero/original/1X/39d83dcbb75bc5d0d8a9502e89fdd195daa46bc3.png)

---

<div class="post-metadata">

**Author:** ![addossantos](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/a/db5fbb/32.png) [@addossantos](https://support.primero.org/forum/u/addossantos)\
**Post date:** [August 11, 2025, 12:28pm UTC](https://support.primero.org/forum/t/how-to-query-a-report-on-cases-open-for-certain-municipality/972/3 "2025-08-11T12:28:35Z")

</div>

I try to create new report but both group by row or by column there is no option for location even on Report filter +new, as screenshot attached  
Thank you

 ![no location to select](https://support.primero.org/uploads/primero/original/1X/8036d5102f121bb77c149eb31c485df49084d8cc.jpeg)  
 ![no location to select1](https://support.primero.org/uploads/primero/original/1X/a4290a583b07fc99d4e697018f4ddd085a12edf9.jpeg)

---

<div class="post-metadata">

**Author:** ![childprotectioninnov](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@childprotectioninnov](https://support.primero.org/forum/u/childprotectioninnov)\
**Post date:** [August 11, 2025, 12:38pm UTC](https://support.primero.org/forum/t/how-to-query-a-report-on-cases-open-for-certain-municipality/972/4 "2025-08-11T12:38:59Z")

</div>

The list under “Group by row” and “Group by column” does not display all options in the drop down as there are many fields that can be selected. Please type in the word “location” to return more specific results.
