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.

    non-toxic cleaning company Winnetka ..
    In The News:

    Researchers are now showing us that old smartphones as data centers could be the next big thing in sustainable tech.
    Scientists have created micro-robots for sinus infection treatment that can enter the nasal cavity, eliminate bacteria directly at the source, and exit without harming surrounding tissue.
    Let's examine how your data is collected in everyday life, who is buying and selling it, what happens to it afterward, and, most importantly, what you can do to protect yourself.
    Researchers at the University of Sheffield in the U.K. developed small robots called "Pipebots" that can travel inside water pipes to find and potentially repair leaks, all without any excavation.
    A groundbreaking new study has uncovered disturbing AI blackmail behavior that many people are unaware of yet.
    Four teams of autonomous humanoid robots competed in China's first AI soccer tournament, demonstrating advanced capabilities in ball detection and independent decision-making.
    The ID. Buzz autonomous van features self-driving technology with 13 cameras, nine LiDAR units and five radars after Volkswagen partnered with Hamburg and Uber for 2026 deployments.
    Social Security phishing scams use urgency and impersonation to steal personal data. Learn how to spot fake SSA emails and implement 10 protective measures.
    French startup Pazzi Robotics created an AI-powered pizza robot that made pies in under five minutes without human help, but it closed in 2022 despite patents and expert partnerships.
    Reclaim your time from big tech with effective screen time reduction strategies for iPhone and Android, featuring steps to limit app usage and create phone-free zones.
    Amazon Prime Day shoppers face threats from 120,000-plus scam websites as cybercriminals prepare phishing traps and malware ahead of the July sales event.
    Fox News' AI Newsletter brings you the latest on this rapidly evolving technology.
    The AEON humanoid robot tackles labor challenges with Nvidia AI, Microsoft Azure cloud and advanced spatial awareness, working alongside industry leaders Schaeffler and Pilatus.
    Google's Ask Photos feature brings AI-powered searches to your photo library, letting you find memories with natural language queries while maintaining privacy controls.
    The return of blue book exams emerges as universities fight widespread AI academic dishonesty and educators debate whether to ban AI tools or teach responsible usage.
    Signs your phone might be hacked include strange behavior, unauthorized texts, battery drain and pop-ups, while protection involves updating software and avoiding public Wi-Fi.
    Tokyo startup H2L has launched Capsule Interface technology enabling full-body robot control with muscle sensors, offering immersive remote operation.
    The A.I. industry seems set for growing pains as Big Tech companies scramble for solutions to the medium's unprecedented strain on the power grid.
    Fourth of July fireworks cause a 60% spike in lost pets, but GPS trackers and AI photo-matching services like Love Lost can help reunite missing dogs with their families.
    Protect yourself from jugging, the rising crime by which thieves monitor ATM users and follow them to steal cash, with six practical safety tips to stay alert and secure.
    U.S. airlines like Delta, American and United are selling your domestic flight records to government agencies through the little-known Travel Intelligence Program.
    Autonomous robots from Uber Eats are rolling out across U.S. cities, featuring LIDAR sensors, secure compartments and all-weather operation for food and grocery delivery.
    Costco has expanded into EV infrastructure with new ultra-fast charging stations that can charge most electric vehicles to 80% in 20-60 minutes while shoppers browse the warehouse.
    The new Gemini Robotics On-Device AI allows robots to perform complex tasks without internet, offering enhanced privacy, reliability and adaptability for real-world use.
    Protect yourself from Amazon phishing scams by spotting red flags like suspicious sender addresses and spelling errors while using Amazon's Message Center to verify communications.

    Software Engineering: An Introduction

    Software Engineering is the Systematic Approach for analysis design implementation... Read More

    Keep Your Software Simple! A Review of EditPlus

    I like my software simple. If it's too complex or... Read More

    Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

    Microsoft Great Plains may be recommended for international freight forwarding... Read More

    Helping Newbies Understand Professional Software

    The Windows registry is a huge database that ensures normal... Read More

    It?s Back!! WordPerfect?s Amazing Comeback

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

    40/sec to 500/sec

    IntroductionSurprised, by the title? well, this is a tour of... Read More

    Microsoft CRM Lotus Notes Domino Connector FAQ

    Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

    Best Spyware Removers

    Finding the best spyware removers to detect and remove spyware... Read More

    Free Microsoft Word Online Training Tutorial Resources

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

    The Opera Alternative

    Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

    Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

    Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More

    Behave, Word, Behave!

    If you copy something from a Web site or elsewhere...... Read More

    Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

    Spyware and malware are large problems for Internet users today... Read More

    Fast Car Knoppix

    Small can be beautiful! Working with Knoppix for the past... Read More

    Causes of ERP Failures

    ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

    MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

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

    Marketing Your WinRunner Team

    It won't matter how effective your WinRunner Team is if... Read More

    Microsoft and Webmasters

    Does Microsoft care for WebmastersIt's always been a problem with... Read More

    DB Integration - Software for Combine MS Access Databases

    Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

    Is Your Computer Sick?

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

    Great Plains Dexterity History and Programming Overview

    As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

    The Hidden Power of Online Manual

    Writing software manuals is boring, isn't it? We often think:... Read More

    Call Alert Notifications - Free Answering Machine Software for PCs

    If you're online using a dialup Internet connection, you'll probably... Read More

    Understanding Document Management

    The term "document management" and "paperless office" is the subject... Read More

    Microsoft CRM USA Nationwide Remote Support

    Remember old good days when your company probably had Great... Read More

    experienced cleaning professionals Glencoe ..