How do I generate a report after comparing attributes

See more:

C++

database

e-commerce

Hi,

Here is the background:

1. A record is created in a r_desc table with 65 columns with plain text and numeric data
2. Later a user chooses to compare the record in r_desc table with matching records in p_desc table for display
3. The user then selects some or all these records and the primary keys of the selected records are appended to the original (baseline) record in r_desc table
4. The user generates a report which shows comparison of the attributes of each record in p_desc with baseline attributes in r_desc and displays chart (bar graphs) with variance.

As I finish writing this message I realize this is like searching for a product on a ecommerce website, retrieving results and adding some of the retrieved records to a wishlist by checking them.

Any help to help me achieve this will be much appreciated.

Thanks.