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.
What do you think about this article? Do you agree or disagree with it? Be the first to comment on this article, and share your thoughts with the world. No registration is required to post comments.
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software...
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. ...
Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is...
Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains...
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...
Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company. Our view point considers the fact of multiple...
Windows 7 giving you more problems than you see fit? Constantly getting error messages like "Microsoft Word has stopped working. Ignore problem or report problem to Microsoft?"
It would seem that Microsoft has been sending Best Buy workers so called "training" material that pretty much warps and attacks the Linux Operating system, according to an anonymous Best Buy worker. The memos
This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.Introduction. Looks like Microsoft...
With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion.Microsoft CRM at this moment doesn't have advanced...
The article aims at youtube download solutions for windows users, to help those people who want to watch youtube video offline download videos to their computer conveniently.
Designing with CAD and 3-D laser systems just got easier with reverse engineering technologies. Thanks to new software developments and add-ons, reverse engineering can now directly be implemented into CAD.
In order to view FLV video on iPad, you need to convert FLV to iPad compatible video formats and then play the converted video files on your iPad with ease. This article mainly tells you how to convert FLV...
Leveraging and consolidating several technologies into a single platform is a trend that many companies are applying to work in offices today. Where project management, communication and content management was
Creation of families in Revit is one of the most proficient and convenient way to minimize the overall project cycle time thus makes the project cost effective.
Technological advancements are rapidly happening today and have dramatically transformed the way any industry operates. And the architectural industry is one that has been hit hard by the tech bug.
We have already talked about the importance of Java Technologies at "Oracle E-Business Suite Customization: New Directions". Not only for Oracle Company itself, but also for the Oracle E-Business customers...
Microsoft Dynamics GP, or Microsoft Great Plains is very popular mid-market generic ERP. It can be used as ERP platform for multiple vertical markets. In this small article we'll describe typical auto...
IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need Audit trail on approval cycle and decision making. Microsoft Business
We will base our prognosis on our Microsoft Business Solutions ERP consulting practice: Microsoft Great Plains, Navision, Axapta, MS CRM. Also we've analyzed Oracle products: Oracle Financials, JD Edwards...
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...
If your company has regional and worldwide operations, you might already realized that it is very hard to get decent Internet connection in your remote locations. In this small article we will try to give you
Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management...
Remember old good days when your company probably had Great Plains Dynamics? If you are in San Francisco Bay Area - you had local Great Plains Software partner consulting company, who served you basically...
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. In earlier 1990th - the customization tool was mostly Great Plains
Microsoft Business Solutions CRM data conversion deserves FAQ type of article, where IT people could get initial directions. Even if it seems as a trivial task, we would suggest you to think about these...
Article: Crystal Reports For Microsoft RMS - Overview For Developer/Report Designer Author: Andrew Karasev Publication Date: 2006-10-27 Total Views: 272 Word Count: 359 Category:Home /
Computers / Software
Categories
