Thank you for your guidance Randy. I just got Crystal Report today.

To recap your thought, I should:
1. Gather the required data thru the exisitng SQL statements
2. Hold the results into a temporary table, that can be released when the report is exited.
3. Design a report using Crystal Reports to present the information to the user.

Am I consistent with what you are telling me? Thanks again.

- Ravi