Crystal Reports w/ Microsoft Retail Management Software

(0) Share

Report

Posted on by jreeves231

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

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Crystal Reports w/ Microsoft Retail Management Software

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')