I am looking to create a report, and to have it download it in CSV format. Here is what needs to be in the report:
- Customer contact info (name, email, mailing address)
- Orders for each customer (date, number of items, total sale amount)
- Products in each order (2 product As, 3 product Bs, etc.)
I'm sure I'm facing some challenges with this, such as:
- how to fit all that data onto single rows of a CSV file
- and how to do all the joins the pull it all together
Am I looking at building a custom module?
Any tips on how I should proceed?
(are there specific modules I should look at as examples? are there specific parts of the API I should look at?)
I should also mention this is for a Drupal 5 site. Upgrading to Drupal 6 _might_ be an option, since I could take advantage of Views 2 there.
I would greatly appreciate any suggestions. Thanks!