Creating a custom report incorporating Customer Maintenance and Item Maintenance info

Hello,

I am trying to create a custom report that would show customer details relating to items sold.

I am looking to include:

Customer Name and associated purchase history of a given item #, item description, standard cost, standard price, and if possible the last purchased date.

Can anyone point me in the right direction? I know you can drill down from item inquiry to get all this info but I need it as a report or exportable to excel.

Thanks!