Crystal Reports w/ Microsoft Retail Management Software

This question is not answered

Hello Everyone,

 

     This is the first time I have posted anything here so I really hope someone can help me.  Right now i am trying to build a custom report within "Crystal Reports for Blackbaud" that will pull all the customer names that have bought a specific item or a list of items (Stock Item Number).  I don' know SQL very well or else I would be using the Microsoft Retail Management Administrator Query console.  Is anyone well-versed enough in this program to help me build this query?  You can get back to me either by posting a reply on this thread or e-mailing me personally at johnreeves231@gmail.com.

     I truly hope someone can help me with this as it is a very important report that I must get completed rather quickly.  I just wish I knew the system and database better then I currently do.

 

Thanks in advance,

 

John Reeves

All Replies
  • Try the following and please let me know your concerns

    select firstname,lastname,accountnumber

    from customer inner join [transaction] on customer.id=customerid

    inner join transactionentry on [transaction].transactionnumber=transactionentry.transactionnumber

    and [transaction].storeid=transactionentry.storeid

    inner join item on item.id=itemid

    where itemlookupcode in ('ggg','fff','ddd')