Home            Links 



 


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.



    Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012
    Reuters
    SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ...
    Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ...MarketWatch (press release)
    Advent Software's CEO Discusses Q4 2011 Results - Earnings Call TranscriptTheStreet.com
    Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick FactsNASDAQ

    all 13 news articles »


    Oakland police get free forensic software to analyze Occupy videos
    San Francisco Chronicle (blog)
    A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ...

    and more »


    Scorpion Software Announces AuthAnvil Single Sign On Support for Level ...
    San Francisco Chronicle (press release)
    Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ...
    Scorpion Software Offers Support for Level Platforms Managed WorkplaceThe Complete Managed Services Resource

    all 2 news articles »


    Caduceus Software Plans to Integrate a Cloud Platform with its Software ...
    SmallCap Network
    By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems.
    Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ...MarketWatch (press release)
    QualityStocks News - Caduceus Software Systems Provides Update on Current ...PR Web (press release)

    all 14 news articles »


    Proposal Software Continues Strong SaaS Revenue Growth in 2011
    MarketWatch (press release)
    WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ...

    and more »


    Manhattan Software Announces Strategic Partnership With Indiabulls for ...
    MarketWatch (press release)
    6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ...

    and more »


    Mezeo Software Announces National Master Distributor for Japan
    MarketWatch (press release)
    HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ...

    and more »


    The Cloud Software Companies You Need to Know About
    Motley Fool
    But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ...

    and more »


    Is BMC Software Growing or Slowing?
    DailyFinance
    By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ...

    and more »


    Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc
    MarketWatch (press release)
    MAYNARD, Mass., Feb 06, 2012 (BUSINESS WIRE) -- Longwood Software, Inc., the developers and marketers of the RevBase(R) software-as-a-service (SaaS) marketing asset management system ( www.revbase.com ), announced today a strategic reseller agreement ...

    and more »

    Google News

    Related Articles
    Performance Tuning of a Daffodil DB / One$DB -JDBC Application
    This article illustrates the best practices to improve the performance of Daffodil DB / One$DB JDBC Driver. This article focuses on how to improve the performance of a Daffodil DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement and ResultSet interfaces. Choosing the right statement interfaces and right methods according to your SQL query plays a vital role in improving the performance of a JDBC Driver.
    FreeDOS
    Before September 1995, Microsoft Windows was an MS-DOS program. DOS was an easy to use command line operating system that provided you with complete ability to control and troubleshoot your computer. Microsoft's goal was to eliminate DOS, possibly to prevent you from having complete control of your own computer.
    Microsoft Great Plains PM: Payables Management
    Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).
    Software Review: Xsitepro Total Site Management Software
    It's not very often I get excited about a software program, but today I'm so excited I just had to tell you about Xsitepro, the top tool for Internet marketers. In particular, those who have been using HTML applications programs like Dreamweaver and Frontpage to produce their Internet media will find this program revolutionary in that it can at least halve your time for site development.
    New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink
    Three highly respected names in Human Resources have joined forces to provide companies with a revolutionary blend of services that make the hiring process more efficient and effective. The partnership joins three companies: NAS Recruitment Communications, a recognized leader in the specialized field of human resource communications, Hannibal, Inc., a software development firm specializing in recruiting automation solutions, and InfoLink Screening Services, Inc., a nationwide leader in employment background screening, drug testing and physical exam services.
    It?s Back!! WordPerfect?s Amazing Comeback
    Have you noticed WordPerfect is gearing up for a comeback in a big way? And fortunately, they are succeeding. If you're like me, an ole' diehard WordPerfect 5 user, this is music to my ears. I love Microsoft Word, but I long for some of the features WordPerfect had to offer.
    Corporate Accounting System: Microsoft Great Plains ? Overview
    Corporate ERP/MRP selection might be tough one, especially considering very turbulent ERP world and fierce competition between Microsoft Business Solutions (Great Plains, Navision, Axapta, MS CRM), Oracle (Oracle Financials, PeopleSoft, JD Edwards), IBM (including Lotus Domino), SAP, Microsiga (Brazil, Portugal). We recommend you, IT director of large corporation, make your home work and decide on Microsoft or Java/EJB/J2EE platform (however you should consider vendor dependence minimization, and stake on both with XML streams integration between the two). In this small article we will concentrate on Microsoft Great Plains, former Great Plains Software Dynamics/eEnterprise/Great Plains Accounting
    Microsoft CRM ? Consulting in the Post-Recession Time
    New post-recession era has new features, which didn't exist in late 1990th during high-tech boom. This will be in our opinion on new directions for Microsoft Business Solutions products consulting, including Microsoft CRM. New features:
    Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE
    Lotus Notes Domino is very efficient in electronic document workflow automation. Unfortunately the electronic document workflow can not replace paper documents completely. For example some documents should be sent to your suppliers or customer in paper form. Lotus Notes (as a client) has built-in tools for printing documents, views and folders. But inbuilt Lotus Notes mechanisms providing such services as printing on the paper Domino database contents can not solve all reports generation objectives.
    Lotus Domino Implementation and Development: Infrastructure ? Present and Future
    Domino server is a buffer between the operation system and the application. On the other hand Domino server ? consists of the services which support development processing and executing of dynamic, secure applications for Internet, Intranet, or Extranet. Domino server role is to provide functionality both: within and between Domino-applications. Domino services interpret codes and elements of application and execute them over actual operation system. Each service is specially optimized for its specific role when Domino is activated for effective functioning of the whole application.
    Exactly What Does FTP Stand for and What Can it do for Me?
    FTP stands for "file transfer protocol". FTP is basically a way of sending files over the Internet.
    Getting Technical Support Help Online
    Sometimes your PC will start acting strange for no apparent reason or a program which you use regularly will all of a sudden stop working as it should. This can be a frustrating experience especially if you have no idea where to go for help. If this happens to you, don't panic! Here are some simple tips which may turn your frown upside down.
    ERP Software Financing: the Future? ? Overview for Company Owner
    In our case ? we serve Microsoft Business Solutions ERP and CRM products: Microsoft Great Plains, Microsoft CRM, Navision, Microsoft RMS, as well as we do customization and integration to these products. We would like to share with you our experience with financing through Microsoft Financial Corporation, the entity handling software financing for Great Plains, CRM, Solomon, Navision & Axapta.
    Microsoft CRM Data Import FAQ
    Microsoft CRM has built-in conversion tool, however you should probably first try third party conversion tool, such as Scribe. It is relatively expensive and has bunch of importing capabilities, that you might never use and need. Scribe allows you to map objects in source and target, when source is ACT! for example. If you are just realized the need to load data into CRM ? please research Microsoft CRM import tool and Scribe. Here we will describe other option and possibilities
    Microsoft Great Plains Data Conversion ? Overview For Developer
    Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.
    Software Automation Helps Increase your Bottom Line
    When you own a small business, time is money. And every time a task that should be automated is handled manually, it wastes your time and your business loses money. To make matters even worse, performing these tasks manually, in front of clients or prospects, projects the wrong image.
    Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example
    Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution ? Microsoft CRM. Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision. In this small article we'll show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes.
    Alien Intruders!
    You probably didn't casually invite, or extend a formal attendance request to, these undesirables known as viruses.
    Understanding XML Server
    XML Server can be a Web Server that stores the XML files in it and serves them on demand. The XML Server would have processing capabilities with an XML engine and to transform the XML document to other forms. Basically a server which hosts and serves the XML documents is called a XML Server.
    Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer
    Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. It has multiple customization/modification/reporting tools. Currently there is upgrade campaign to version 8.0 and due to the discontinuation of the technical support for Microsoft Great Plains Standard on Ctree and Pervasive SQL - we see substantial increase in migration needs: migration from ctree/Pervasive to MSDE/MS SQL Server. This in turn increases interest to customization and customization upgrade.



    Common misspellings for words used in this page include abilty accoring acording adminstrator adn ahev ahve amke anbd aparent aplication apparant applicaiton applicaitons aroud arround artical artice articel arund attendence attension baceause backgorund baout basicaly basicly beacuse becasue beccause becouse becuase betwen bewteen buisness busineses busness bussiness campain carefull comback competion competitiion concider concidering conection consdider consentrate consttruction constuction controll contruction convertion decribe delevopment dependance deside desigining developement develpment devolopement diea discribe doccument doccuments driectly durig durring duting effecient efficent ened entitity especialy ethose eveyr excecute excecuting exemple exmaple expecially experiance expierence extemely extrememly extremly fidn fiel focusses fomr frome fucntioning haev headquaters howver hten htere htey htis hvae hvaing hvea hwihc hwole idaeidae inbetween includng incuding inlcuding inot inproving intergrated intergration interpet intrest iwll iwth jstu jsut larg liek liuke loev lveo lvoe mkae mkea moreso mroe nowe nto oftenly omre oppinion otehr owrk owudl pary performence possably probablly probaly proccess proccessing proces provded realitvely reasearch reccomend reccommend recomend reconized recuiting reguarly regularily relativly relitavely revolutionar severeal sevice shoudl shoudln smae smoe soem sofware sohw specfic specif spectum stange statment stpo strat substancial substatial sytem taht targetted tath technnology technolgy teh tehy tghe thast theese ther theri thgat thge thier thn thne threee thrid thru thsi thsoe thta thyat tiem tihs timne tiome tje tjhe todya tranform tyhat tyhe uise useing vell verison vetween veyr vrey vyer vyre wass watn weas wehn whant whcih whic whihc whith whlch whn wich wiew wih wiht wille withing witht witn wiull wnat wohle wokr wokring worls woudl wrok wroking ws wtih wupport ytou yuo.