Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we would like to give you the clues on Crystal Report creation for Microsoft RMS

  • Database: Microsoft SQL Server or MSDE - this means that you can deploy native SQL driver for connection or use ODBC for flexibility.

  • Tables Structure ? it is extremely self-explanatory: Customer, Transaction (invoices, returns, layaways and others), TransactionAmount, Cashier, Tender to give you examples

  • Links - Usually master table has ID column and Transaction-related table links by [Entity]ID column: Transaction.CustomerID=Customer.ID to give the idea. This query will give you customer info of sales transaction: select b.FirstName, b.LastName, a.* from [Transaction] a join Customer b on a.CustomerID=b.ID. Please pay attention to the brackets around Transaction - transaction is reserved word in MS Transact SQL - the Microsoft blend of SQL92

  • Hints on dataflow/synchronization ? Microsoft RMS uses worksheets technology and all the data goes from stores to headquarters database through worksheets. Headquarters database doesn't create its own transactions - so be careful and do not try this type of data integration.

  • SQL Views and Stored Procedures - yes - feel free to create them directly in RMS Headquarters database and deploy in your Crystal Report.

  • Advanced Techniques - in MS SQL Enterprise Manager you can create Linked Server to all ODBC/OLEDB compliant databases: Ctree, PervasiveSQL/Btrieve, MS Access, ORACLE, DB2, Unidata, Navision (C/ODBC) and using OPENROWSET construction you can create geterogeneus view and stored proc - then you can have the data from multiple systems in your Crystal Report.

    • Happy designing and developing! if you want us to do the job or use our product - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Arizona, California, Colorado, Texas, New York, Georgia, Florida, Canada, UK, Europe and having locations in multiple states and internationally (www.albaspectrum.com), he is MS RMS, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    pen paper and inkwell


    cat break through


    Guide to Software Marketing

    Intro This concise article will tell you in plain English... Read More

    Groupware: What Works the Way Businesses Do?

    GroupwareThe internet is full of 1.5 million to 7 million... Read More

    Exactly What Does FTP Stand for and What Can it do for Me?

    FTP stands for "file transfer protocol". FTP is basically a... Read More

    Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

    Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

    Microsoft Great Plains ? Licensing & Product Versions

    Current Microsoft Business Solutions Great Plains has more that 10... Read More

    Microsoft Great Plains Security Setup - Overview For Consultant

    Microsoft Business Solutions Great Plains is very good fit for... Read More

    Five Steps to Rapid Development with TierDeveloper 4.0

    Follow the steps below to quickly design, generate, and deploy... Read More

    ERP Consulting: Microsoft Great Plains Partner Future Directions

    In the Clinton era the status quo was simple: you... Read More

    Partitioning, Formatting and Reinstalling in Windows 98

    Formatting and reinstalling windows 98 is very easy if you... Read More

    Is Your Computer Sick?

    Viruses and spyware usually show up on your computer one... Read More

    Microsoft CRM Implementation & Remote Support

    We would like to give you pluses and minuses of... Read More

    Crystal Reports for Microsoft Great Plains ? Overview for Developer

    Microsoft Great Plains is main accounting / ERP application... Read More

    Razzle Dazzle Them

    Once upon a time not so long ago, there was... Read More

    Linux for Home Users

    Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

    C++ Tutorial 1, Introduction to C++

    Introduction to C++Why Learn C++?C++ may at first seem like... Read More

    Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

    With this small article we are continuing Microsoft Business Solutions... Read More

    A Simple Guide To Wikis

    A wiki is an editable text-based website. But you don't... Read More

    Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

    Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

    Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

    Microsoft Great Plains fits to majority of industries, in the... Read More

    Spyware, Adware, etc. -- Terms and Common Sense

    When reading an article where some term is used often,... Read More

    Run Your Own Search Engine

    Our hosted solution allow you to run your own search... Read More

    Microsoft RMS Customization ? PO Items Receiving in Great Plains

    Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More

    Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

    Manufacturing in the USA is far away down from mid... Read More

    Software Process Improvement -A Successful Journey

    Background: For many organizations like ours, the interim target of... Read More

    Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

    Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

    Great Plains Dexterity Development: FAQ

    Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

    C++ Tutorials: 3, Program Flow (If, Else, While, For)

    Program Flow is what you think it is. How the... Read More

    Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

    Microsoft Business Solutions CRM is present several years on the... Read More

    Perfectly New Database Query Tool - Foxy SQL Pro Released

    Are you a database professional? Do you work with a... Read More

    Microsoft CRM and No-Frills Cadillacs

    In today's business world it's all but impossible to escape... Read More

    Groupware as a Document Manager: Collaboration Series #3

    This article is the third of a series of articles... Read More

    Beware of The Pirated Software E-Mail Scams!

    You have gotten those E_Mails buy software at deep discounts.... Read More

    Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

    It is possible that if one avoided all sources of... Read More