Software Information

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.


    MORE RESOURCES:

    Business Wire (press release)

    Elliott Terminates Tender Offer to Acquire Epicor Software Corporation
    MarketWatch - Nov 21, 2008
    ... LP and Elliott International, LP (collectively, "Elliott" or "we"), a major shareholder of Epicor Software Corporation (the "Company" or "Epicor"), ...
    Epicor drops after hedge fund ends hostile bid Forbes
    Hedge Fund Elliott Associates Withdraws Offer for Epicor Software Orange County Business Journal
    UPDATE 1-Hedge Fund ends offer for Epicor Reuters
    RTT News - Barron's Blogs
    all 45 news articles


    New York Times

    The best thing about the 2.2 iPhone software update
    CNET News, CA - Nov 21, 2008
    When it some to iPhone software updates, I'm all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia ...
    First Look: Apple's iPhone 2.2 Software Hits The Street (And ... CRN
    Lots to like about new iPhone 2.2 software update Ars Technica
    Apple releases iPhone Software v2.2 Apple Insider
    G4 TV - infoSync World
    all 143 news articles


    Canada.com

    Microsoft: New software not Symantec, McAfee rival
    Reuters - Nov 19, 2008
    BOSTON (Reuters) - Microsoft Corp's upcoming security software is not designed to take sales from Symantec Corp and McAfee Inc as it is a stripped-down, ...
    Microsoft to offer free security software to attract beginners eTaiwan News
    Microsoft Plans to Introduce Free PC Security Software Wall Street Journal
    Microsoft to offer free security software NetworkWorld.com
    Washington Post - Bizjournals.com
    all 304 news articles


    Vertical Releases Feature-Rich Software Update for Wave
    MarketWatch - 20 hours ago
    ... today announced the release of the Wave 1.5 software upgrade to it's award winning Wave IP 2500(TM) Business Communications Solution, the industry's ...


    Hann’s On Software bouht by Mediware
    Bizjournals.com, NC - Nov 21, 2008
    Mediware Information Systems Inc. has bought the assets of Hann’s On Software, a pharmacy-management software provider based in Santa Rosa, for $3.5 million ...
    Mediware Information buys assets of Hann's On Software - Quick Facts RTT News
    Mediware Acquisition Adds 320 Pharmacy Facilities CNNMoney.com
    all 19 news articles


    Canada.com

    BlackBerry Storm Sales Delayed By Software Glitch? Screen Gimmick ...
    Silicon Alley Insider, NY - 27 minutes ago
    RIM's new BlackBerry Storm is proving to be popular with some people -- many Verizon Wireless stores sold out of their first batches yesterday. ...
    Software Flaw Might Cause BlackBerry Storm Shortage eFluxMedia
    Storm Is a Fun BlackBerry, but No iPhone Killer U.S. News & World Report
    8 Reasons to Pick iPhone Over BlackBerry Storm PC World
    ZDNet Blogs - engadget
    all 653 news articles


    AVG Sees Uphill Battle for Microsoft in Its Launch of Free Anti ...
    MarketWatch - Nov 21, 2008
    AVG, which for eight years has offered free anti-virus software to users worldwide, noted the multiple challenges Microsoft faces in supporting a free ...
    AVG sees 'uphill battle' for Microsoft Morro TechRadar UK
    Microsoft Announces Upcoming Events for the Financial Community NewsBlaze
    Microsoft Announces Upcoming Events for the Financial Community MarketWatch
    all 30 news articles


    Microsoft’s Mike Neil Keynotes at SYS-CON's 4th International ...
    SYS-CON Media, NJ - 19 hours ago
    ... Black Duck Software, Blackbaud, Blade Network Technologies, Blue Coat, Blue Lane, BlueArc, BlueNote Networks, BluePheonix Solutions, BMC Software, ...
    Teaching Everyone to Speak Big Blue New York Times
    IBM To Acquire Virtualization Specialist Transitive InformationWeek
    IBM To Buy Virtualization-Software Company Transitive NewsFactor Network
    eWeek - SearchDataCenter.com
    all 95 news articles


    Frankly speaking, speech software better but still not great
    Seattle Times, United States - 12 hours ago
    Getting a computer to turn your speech into words on the screen requires buying expensive, resource-intensive software and mastering a sometimes confusing ...


    Microsoft purges phony security software from 1 million PCs
    Computerworld, MA - 23 hours ago
    Windows users have been plagued with a flood of worthless security software in recent months as criminals have discovered that they're money-makers. ...

    Software - Google News

    home | site map
    © 2006