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


    CRM 101: Customer Relationship Management for Beginners

    Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

    Spyware: What It Is and How to Combat It

    Spyware is software or hardware installed on a computer without... Read More

    Microsoft C# vs. VB.Net

    Hi, Guys,I believe a lot of programmers are trying to... Read More

    Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

    Bad News - the Threat is Bigger than it SeemedHow... Read More

    Groupware: What Works the Way Businesses Do?

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

    Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

    Many reasons made GBM a unanimous choice for experts, one... Read More

    Running a Program on a Remote Server Using SSH

    How do you run a program on a remote server... Read More

    Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

    Microsoft Business Solutions Great Plains has many years of successful... Read More

    Photoshop Files and Formats

    People often ask me: What image file formats will Photoshop... Read More

    Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

    Microsoft Business Solutions Great Plains has substantial market share among... Read More

    Groupware: Answers the 5 Questions of Document Collaboration

    Every organization which creates collaborative documents, whether they are budgets,... Read More

    Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

    When you visit department stores and see that majority of... Read More

    Microsoft Great Plains Integrations ? Retail Management Sample

    Microsoft Business Solutions is emerging as very attractive vendor for... Read More

    SyncUp ? A File/Folder Synchronizer For Windows

    SyncUp, a file synchronizer is designed to assist the home... Read More

    Are You Waiting for Microsoft Longhorn Operating System

    I love new technology. I am still ready to wait... Read More

    Do You Know These Facts About Spyware ?

    Imagine something that follows you home and sets itself up... Read More

    Explore the Internet in a Whole New Way

    For a long time now Microsoft's Internet Explorer has ruled... Read More

    Best Practices In Choosing Network Monitoring Software

    Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

    Great Plains Dexterity: Customizations & Source Code Programming

    Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

    Groupware as a Document Manager: Collaboration Series #3

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

    Who?s Watching What You Type?

    If someone entered your home, uninvited and installed numerous cameras... Read More

    Windows Screensavers Explained

    In this article you will find some background information about... Read More

    MSN Messenger Is A Sweet Way To Communicate

    MSN messenger is a pretty cool invention. I mean I'm... Read More

    S is for Spying, Surveillance -- and for Software as Well

    Words we choose to describe things and phenomena often show... Read More

    Basic Tips and tricks for Windows XP

    Running Applications in Compatibility Mode With Windows XP, you can... Read More

    Microsoft CRM Data Conversion FAQ

    Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

    These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

    1. What determines the software price? Is it Per Seat... Read More

    C++ Tutorial 1, Introduction to C++

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

    Microsoft Great Plains Integration Manager ? Advanced Techniques

    Great Plains Integration Manager scripting and translation - overview for... Read More

    It?s Back!! WordPerfect?s Amazing Comeback

    Have you noticed WordPerfect is gearing up for a comeback... Read More

    Programming Environments And The Software Production Process

    Introduction: The creating of a computer program involves a number... Read More

    Theres Gold in Your Websites Server Log

    Many Webmasters have never bothered to view their website's server... Read More

    Reduce Pop-ups and Annoying Ads

    There is many things more frustrating than surfing a website... Read More