For that, use a simple query report. A server script report is harder to develop from the UI side. If you need to write complex logic and create a more advanced report, then use the server script and build it in your custom app.
If you want to develop a query report, you can check this reference: I need script report or query report for lead transaction - #6 by NCP