Article View

Microsoft Retail Management System (MS RMS), erst famous as QuickSell 2000, is an desegrated retail direction code fashioned to support diminutive and medium-sized retailers to automate their playing processes. It runs on individualized computers and crapper be utilised by practically whatever identify of a retail environment: fair goods, plaything stores, lavatory matter stores, contrivance stores, intoxicant stores, meet to study a few. It crapper also support curb a sort of accumulation and office dealings including listing control, employee management, acquire orders, and income tracking.

Microsoft RMS uses worksheet technology, wherein updates from Headquarters are deployed to the stores by generating a worksheet with a given command. The stores, on the another hand, upload accumulation including income dealings and acknowledgement journals backwards to Headquarters. These transactions are not generated from Headquarters. It is, therefore, not owlish to endeavor accumulation combining of much transactions between the digit entities (store and headquarters).

Crystal Reports is a report-writing code that crapper combine itself to Microsoft RMS database. It goes beyond the inform creation impact of RMS’ possess Report Writer. As a developer, Crystal Reports module support your computer admittance decision-driving aggregation to assistance in managing their businesses more effectively.

The mass are whatever guidelines in using Crystal Reports in Microsoft RMS:

Microsoft SQL Server or MSDE

A autochthonous SQL utility crapper be deployed in RMS to enter to the database targeted for inform generation.

You crapper also ingest Open Database Connectivity (ODBC) – an combining agency to enter a computer covering to an ODBC-compliant database. Microsoft RMS uses the ODBC drivers installed by Microsoft SQL Server. Once it prompts you to enter to the pertinent accumulation source, opt the consort database that you are targeting that contains the accumulation necessary for your Crystal Reports.

Tables Structure

When a playing entity is processed, the aggregation is cursive onto the RMS database tables. The tables scheme is self-explanatory. Entities allow Customers, Transactions, Supplier and Tender.

Links

The officer plateau in Microsoft RMS commonly displays an ID Column and the Transaction linked to it: Transaction.CustomerID=CustomerID. If you were to create a ask that module pass client aggregation and income transactions, do the mass statement:

Select b.FirstName, b.LastName, a.* from [Transaction] a tie Customer b on a.CustomerID=b.ID

Use this noesis to create course for your inform creation.

SQL Views and Stored Procedures

Since Microsoft SQL crapper be deployed in RMS, you hit oceanic admittance to SQL Views and fulfil a sort of Transact-SQL statements into digit using Stored Procedures.

Advanced Techniques and Tips

You crapper create a unification computer in Microsoft SQL Enterprise Manager to enter to every ODBC/OLEDB-compliant databases (Ctree, PervasiveSQL/ Btrieve, MS Access, Oracle, DB2, Unidata) and C/ODBC-compliant database much as Navision.

You crapper also ingest the OPENROWSET keyword in MS SQL to create a bet of linked databases for your Crystal Reports.

Need more information?

Contact us:

1-866-528-0577

help@albaspectrum.com

For customization impact and advice, gratify occurrence saint Karasev, Alba Spectrum Chief Technology Officer. His entireness allow utilization of applications with the ingest of Dexterity, SQL, C# .NET, Crystal Reports and Microsoft CRM SDK.