Crystal Reports For Microsoft RMS - Overview For Developer/Report Designer

If you& 39;re a developer or database administrator - we would like to give you understand about Crystal reporting for Microsoft RMS

Database: Microsoft SQL Server or MSDE - which means that you can deploy SQL native driver to connect or use ODBC for flexibility.

Tables structure - this is an extremely self-explanatory: the client, the transaction (invoices, returns, layaways, etc.), TransactionAmount, cashier, Tender to give you examples

Links - usually a master table ID column and transactions involving references to the table [ actor] ID column: Transaction.CustomerID = Customer.ID to the idea. This request will give you information from the customer sales transactions: choose b.FirstName, b.LastName, a. * With [transaction] to join a customer of a.CustomerID = b.ID. Pay attention to the brackets around the transaction - the transaction is reserved word in MS Transact SQL - Microsoft combination SQL92

Hints on dataflow / synchronization - Microsoft RMS use of electronic technologies, and all the data coming out of stores in the headquarters of the database using spreadsheets. The headquarters of the database does not create its own transactions - so be careful and do not try this type of data integration.

SQL views and stored procedures - yes - do not hesitate to create them directly to the headquarters of RMS database and place in your Crystal Report.

Advanced Tech - in MS SQL Enterprise Manager, you can create Linked Server for all ODBC / OLEDB compatible databases: Ctree, PervasiveSQL / Btrieve, MS Access, Oracle, DB2, Unidata, Navision (C / ODBC) and using OPENROWSET construction can create geterogeneus view and store proc, - then you can get data from multiple systems in your Crystal Report.

Happy design and development! if you want us to do the job or use our product - we call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is chief technology officer at " Alba & quot; " Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM, Microsoft RMS settings company, based in Chicago, Arizona, California, Colorado, Texas, New York, Georgia, Florida, Canada, Britain, Europe and having locations in several states and internationally (www.albaspectrum.com), he is MS RMS, dexterity, SQL, C . Net, Crystal Reports and Microsoft CRM SDK developer.



Bookmark it: