Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Crystal Reports w/ Microsoft Retail Management Software

Posted on by 30

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans