| If you are software developer or database | | | | 4. Hints on dataflow/synchronization - Microsoft RMS |
| administrator - we would like to give you the clues on | | | | uses worksheets technology and all the data goes |
| Crystal Report creation for Microsoft RMS | | | | from stores to headquarters database through |
| | | | worksheets. Headquarters database doesn't create its |
| 1. Database: Microsoft SQL Server or MSDE - this | | | | own transactions - so be careful and do not try this |
| means that you can deploy native SQL driver for | | | | type of data integration. |
| connection or use ODBC for flexibility. | | | | 5. SQL Views and Stored Procedures - yes - feel |
| 2. Tables Structure - it is extremely self-explanatory: | | | | free to create them directly in RMS Headquarters |
| Customer, Transaction (invoices, returns, layaways and | | | | database and deploy in your Crystal Report. |
| others), TransactionAmount, Cashier, Tender to give | | | | 6. Advanced Techniques - in MS SQL Enterprise |
| you examples | | | | Manager you can create Linked Server to all ODBC |
| 3. Links - Usually master table has ID column and | | | | OLEDB compliant databases: Ctree, PervasiveSQL |
| Transaction-related table links by [Entity]ID column: | | | | Btrieve, MS Access, ORACLE, DB2, Unidata, Navision |
| Transaction.CustomerID=Customer.ID to give the idea. | | | | (C/ODBC) and using OPENROWSET construction |
| This query will give you customer info of sales | | | | you can create geterogeneus view and stored proc - |
| transaction: select b.FirstName, b.LastName, a.* from | | | | then you can have the data from multiple systems in |
| [Transaction] a join Customer b on a.CustomerID=b.ID. | | | | your Crystal Report. |
| Please pay attention to the brackets around | | | | Happy designing and developing! if you want us to do |
| Transaction - transaction is reserved word in MS | | | | the job or use our product - give us a call |
| Transact SQL - the Microsoft blend of SQL92 | | | | 1-866-528-0577! |