For long we have all suffered with the extensive customizations done to PeopleSoft system to support self-service reporting. How I always wished there was a generic framework that could be configured to deliver a configurable run control page from which managers/employees can run custom reports. Finally some headway has been made in the right direction in PeopleSoft 9.2. PeopleSoft 9.2.002 now comes with a self service reporting framework that can be configured to deliver XML reports using a reporting pagelet. I tried the functionality and its pretty straight forward. It let users run report created with XML doc or Query as source (no connected query support currently).
Below I have made a video of using one such report. Enjoy!
PeopleSoft Tricks and Tips 