Data Analysis and Report generation depending upon user selection

[rpk2006]

I developed a software for a client who recently asked me to add a feature for Data Analysis. He wants that Reports should be generated depending on his record selection criteria. He wants to select fields from tables and the Report should be generated depending upon his selection. I am puzzled as to how to add this feature in VB 6 so that a client can retrieve desired information from Access XP database. The problem is that client has no knowledge of SQL and I have to apply any technique with which even a novice can retrieve any information.
Is there anything to do with DataWarehouse?