Customized serial number monitoring report

hi experts,

I need to create a customized report to monitor the serialized rental equipment that have been returned and loaned to customers. Currently, the serial number transaction report can be helpful to monitor the history per serial number but the user would like to have a summary report for all serial numbers per item per given date range. I tried looking at the database tables and I found out that both RSRN and RITL are not accessible to the user. Is there a way I can create this report and use other relevant tables?

Thanks in advance.

Ana