You can create reports and store them in ePO - On-prem.
Select Menu → Reporting → Queries & Reports, then select the Reports tab.
Click New Report.
Click Name, Description, and Group. Name the report, describe it, and select an appropriate group.
Click OK.
Use the items in the Toolbox and the links on top of the page to add, remove, rearrange elements, customize header and footer, and change the page layout.
Select Runtime Parameters.
In the Runtime Parameters window, set conditions applicable to the respective fields.
Click Save.