Go To Software Information Home
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.
|
 |
|
|
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.
|