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


    Microsoft CRM ? Consulting in the Post-Recession Time

    New post-recession era has new features, which didn't exist in... Read More

    String in Java

    Handling character strings in Java is supported through two final... Read More

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

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

    New SQL Delta Version 3.1

    COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

    What is Groupware?

    Vince Lombardi once said that, "The achievements of an organization... Read More

    Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

    Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

    What is Software Piracy?

    There are several kinds of software piracy. The bottom line... Read More

    Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

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

    Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

    C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

    How to Choose the Right Accounting Software for Your Business

    With any good luck and a good amount of hard... Read More

    Free Microsoft Word Online Training Tutorial Resources

    Microsoft Word is one of the most popular office applications... Read More

    Quick Summary of Basic and Common Linux Commands

    There are many commands that are used in linux on... Read More

    Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

    Microsoft CRM Customization Secrets ? Second Edition

    This article is for advanced Microsoft CRM SDK C# developers.... Read More

    Enterprise Resource Planning Overview

    ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

    Who Is Minding Your Sensitive Data?

    Stealing company information used to be the specialty of spies... Read More

    Mapping Software: Putting Data Visualization on the Map

    Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

    CRM 101: Customer Relationship Management for Beginners

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

    10 Ways to Learn a Software

    Following tips help you to learn a software in lesser... Read More

    Microsoft Great Plains IV: Inventory Management

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

    Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

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

    Online PowerPoint Presentation ? Convert PowerPoint to Flash

    Although we don't know whether Microsoft ever envisioned such a... Read More

    Huddle Up; Groupware on Three

    It could just be me, but my experiences with document... Read More

    Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

    Usually workflow & messaging is realized in CRM and then... Read More

    Dreamweaver vs FrontPage

    There are two major WYSIWYG(What You See Is What You... Read More

    Your Computer May Be Infected, Heres How To Check (NOT about virus)

    NOTE: Please take time to read on - it may... Read More

    Does Microsoft have any real competition?

    Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

    Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

    In this small article we will show you the possible... Read More

    Twelve Things You Should Know to Save on Computer Software

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

    Spyware Protection: A Must for Any Home Computer

    Now that spyware is the single most dangerous threat to... Read More

    Does your Company have Documentum?

    Are you lost in the mess of documents that get... Read More

    How to Make Attractive and Effective PowerPoint Presentations

    Microsoft PowerPoint has dramatically changed the way in which academic... Read More

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

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