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 or Siebel

    Siebel is traditional CRM market leader, however and mostly due... Read More

    Microsoft Great Plains Integrations - Tips for Developer

    In this short FAQ style article we would like to... Read More

    Microsoft Great Plains Customization: Project Organization ? International Business Example

    Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

    Software: What Suits Me?

    Almost all new and major brand of PCs come with... Read More

    Business Plan Software Review: Ultimate Business Planner?

    One of the main reasons business owners and entrepreneurs use... Read More

    The Dreaded Paper Label - Should it be Used?

    While paper labeling CDs and DVDs may appear to be... Read More

    Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

    Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

    Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

    Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

    OSI Layers Model

    IntroductionDuring the early years of our modern computer era, very... Read More

    Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

    How the Firefox: How to... Manual Helped Me

    A few months back I really got sick of my... Read More

    What You Must Know About Spyware Right Now

    Spyware is like the new technological nuclear weapon on the... Read More

    Anti-Spyware Protection ? Holes in the Shining Armor

    Looking at all the ads which promise to get rid... Read More

    Reduce Pop-ups and Annoying Ads

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

    It?s Back!! WordPerfect?s Amazing Comeback

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

    Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

    Great Plains Fixed Assets Management module is a robust tool... Read More

    Recovering Microsoft Great Plains Customization ? Tips for IT Director

    Remember nice and prosperous Clinton era? When you implemented innovative... Read More

    Great Plains Customization ? Programming Auto-apply in Accounts Receivable

    Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

    How Do I Get Rid Of That Darn Spyware?

    Ad-Aware and Spybot are probably the two most well known... Read More

    Is Your Small Business Ready For A CRM Software Solution?

    I have yet to see a business that, sometimes in... Read More

    eConnect: eCommerce Development for Microsoft Great Plains

    Microsoft Business Solutions Great Plains has several options to enable... 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

    Spyware - The Internet Devil Of Our Times!

    Spyware and Adware infest over 90 percent of computers in... Read More

    What is Groupware?

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

    5 Easy File Management Tips in Microsoft Word

    How many steps does it take you to locate and... Read More

    Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

    This is intermediate level SQL scripting article for DB Administrator,... Read More

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

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

    Top Questions to Ask Before Buying a Help Desk & Asset Management Software

    #5 All your hardware components like Printers, PCs etc come... Read More

    10 Ways to Learn a Software

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

    Microsoft CRM for Large Corporation ? Security

    Microsoft Business Solutions CRM proved to be reliable solution in... Read More

    Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

    Microsoft Business Solutions is now in process of creating so... Read More

    Adware, What Is It?

    Adware is a type of Spyware program that displays some... Read More

    Microsoft CRM for Corporate Business ? Working Offline

    If your company has regional and worldwide operations, you might... Read More