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


    Is Your Computer Sick?

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

    IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

    Microsoft Great Plains as ERP and Microsoft CRM as... Read More

    Why Java RDBMS?

    It is a well known fact that Java as a... Read More

    Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

    Microsoft Retail Management System serves retail single store as well... Read More

    Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

    Microsoft bought Navision, Denmark based software development company, along with... Read More

    Microsoft Great Plains e-Commerce ? additional considerations for programmer

    Microsoft Great Plains, designed back in 1990th as database transferable... Read More

    Business Planning Software

    Once a business idea is selected, it is highly recommended... Read More

    Fleet Maintenance Software Reviews

    Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

    Configure Windows Indexing Service for Performance

    The Windows Indexing Service provides you with the ability to... Read More

    Free Software - Powerful Alternatives to Budget-Busting Software

    When you buy a computer, it most likely comes with... Read More

    eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

    eStore Advantage allows front-office applications to communicate with back-office business... Read More

    The Top 5 Wrong Reasons For Not Hiring Testers

    Considering whether or not your software company should hire a... Read More

    Lowering The Risks In Developing Do-It-Yourself Software Projects

    Mike Dunville* had a decision to make. As the new... Read More

    IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

    Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

    Adware and Spyware

    What is 'adware'?Adware is basically software or scripts that are... Read More

    Twelve Things You Should Know to Save on Computer Software

    Do you want to get quality software at a reasonable... Read More

    Software Process Improvement -A Successful Journey

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

    Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

    Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

    Tools for Customizing Great Plains

    Microsoft Business Solutions ? Great Plains has captured the US... Read More

    A Case Study on Selecting Contract Management Software

    Professional services firm cuts costs and improves productivity with integrated... Read More

    Microsoft Great Plains Customization Tools ? Overview

    Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More

    Microsoft Great Plains Middle East - Arabic Language Support

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    The Death of Windows

    I have always regretted how Microsoft price gouges and rips... Read More

    Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

    Microsoft Great Plains might be considered as ERP platform to... Read More

    Microsoft Great Plains IV: Inventory Management

    Great Plains Inventory Management (IV) module gives your business a... Read More

    Do You Want Your Own Fully Programmable ERP? - Part 1

    We are in a transition phase in the Managerial Administration... Read More

    Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

    Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

    Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

    Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

    Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

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

    Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

    It would be easy to think, like most people apparently... Read More

    Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

    Microsoft bought Navision, Denmark based software development company, along with... Read More

    MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

    If you look back to the history, you will see... Read More