This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Strictly speaking, you should never have a resultset in a servlet. DB access should happen at a lower layer, with non-DB constructs passed up to the UI layer. If you're doing your DB access in a servlet, you're not following best practices (MVC) for web app design.
That said, regardless of where you do the DB access, you should copy the data from the resultset into another construct (Lists, arrays, whatever makes the most sense for the nature of the data) and close the rsultset and statement as soon as possible.
For reporting, are you rolling your own, or using a prefab reporting package? That might dictate what format you transform the resultset data into. For simply showing a grid of data on a JSP, copying the data into a simple Object can work just fine.