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.

    green cleaning service Park Ridge ..
    In The News:

    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.
    GAC Group's new Govy AirCab flying car combines lightweight design with advanced safety systems and smart cabin technology to revolutionize city travel with an 18.6-mile range.
    The Berkeley Humanoid Light (BHL) is a lightweight, open source humanoid robot that anyone can build using 3D-printed parts and off-the-shelf components.
    Meta’s new AI chatbot is getting personal, and it might be sharing more than you realize.
    A new threat targets both Android and iPhone users: SparkKitty, a powerful mobile malware strain that scans private photos to steal cryptocurrency recovery phrases and other sensitive data.

    Business Plan Software Review: Ultimate Business Planner?

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

    Linux for Home Users

    Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

    Theres Gold in Your Websites Server Log

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

    What is a Document Manager without Version History?

    Document Manager and Version HistoryIn previous articles I have discussed... Read More

    Keeping Track

    One of the things we can be as certain of... Read More

    10 Ways to Learn a Software

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

    Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

    Microsoft Great Plains and Microsoft CRM become more and more... Read More

    Microsoft Great Plains Integration Manager ? Advanced Techniques

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

    The Bluebird Project

    The objective for Zandi Digital is to make available clever... Read More

    How to Tell You Have Spyware, Ad-ware or Viruses

    Usually, the easiest way to tell you have spyware is... Read More

    Performance Tuning of a Daffodil DB / One$DB -JDBC Application

    This article illustrates the best practices to improve the performance... Read More

    Create A Flash Presentation For Free With Open Office

    The intentions of this short tutorial are not to teach... Read More

    Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

    Currently Microsoft Business Solutions is on the way of creating... Read More

    Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

    IBM Lotus Notes with Domino email server is traditional document... Read More

    Free PDF Publishing Software

    In a previous article, I wrote about OpenOffice... Read More

    Popular Fleet Maintenance Programs

    Some companies that are in need of fleet management may... Read More

    CRM and Customer Life Cycle

    Customer Relationship Management or CRM is a combination of enterprise... 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, Navision, Axapta ? Selection Considerations

    During the years of our consulting practice, which comes back... Read More

    Who?s Watching What You Type?

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

    Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

    Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

    PHP On-The-Fly!

    IntroductionPHP can be used for a lot of different things,... Read More

    What to Do if All Screensavers Fun is Grayed Out?

    Finally, you have some time to personalize your desktop with... Read More

    Microsoft CRM Development

    Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

    Microsoft Great Plains BR: Bank Reconciliation

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

    emergency cleaning services Morton Grove ..