Microsoft Business Solutions Navision is prevalent ERP candidature for European, Brazilian markets plus it serves unsloped segments of the USA market, specified as street light manufacturing, POS, CRM. As our undertake indicates - Navision carrying out requires more customization and standardization in comparison to different mid-market ERP solution from MBS: Microsoft Great Plains. Our mental object is to popularise Microsoft Business Solutions products and advance IT general public to do create Navision in-house.
Today, the leading substance of this nonfictional prose is exploitable next to original C/SIDE Navision Attain database via C/ODBC interface, in picky - Linked Server production in Microsoft SQL Server 2000 environment and then Sales report designing in Crystal Reports ver. 10. Let's begin:
1. We will use Navision Attain 3.6 next to Navision Database Server, Navision ApplicationServer and Navision Client. These division are installed on Windows XP Professional. To change C/ODBC surface you condition to induct this component from Navision Attain CD.Post ads:
2. Let's generate ODBC DSN for association to Navision database: Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC), after switch to System DSN and clink Add. We will use C/ODBC 32-bit manipulator. Give Data Source Name Navision, Connection - move it Local. As the database (Database fastener) quality \\Program Files\\Navision Attain\\Client\\database.fdb (this is demonstration DB). Then constrict Company control - in our skin we use CRONUS demo info. Important conditions to distribute straight-laced seam near C/SIDE database are correct options for C/ODBC. Click Options fastening and countenance at the options available - we will pay limelight to Identifiers eyeshade - this is wherever you apparatus identifiers to be transferred to client submission. We will use these types: "a-z,A-Z,0-9,_" to net MS SQL Server 2000 pursue accurate with C/ODBC derivation. We are now through with with ODBC DSN. Lets setup Linked Server
3. Open SQL Server Enterprise Manager. Open jib witness on the left side, superior Security and Linked Servers. With letter-perfect sound prize New Linked Server in the context menu. In the appear dialog window, in the card Provider Name prime Microsoft OLE DB Provider for ODBC Drivers. Let's first name our Linked Server as NAVISION. In the Data Source yarn kind in ODBC DSN given name - NAVISION in our lawsuit. Linked Server is geared up. Select tables document and we now see Navision Attain tables.
4. Now we inevitability to devise minute regulation for Sales aggregation activity. Here is the essay of the procedure:
CREATE PROCEDURE NavisionSalesReport AS
DBCC TRACEON(8765)Post ads:
SELECT * FROM OPENQUERY(NAVISION, 'SELECT * FROM Sales_Line sls, Customer cust WHERE sls.Sell_to_Customer_No_ = cust.No_')
To clarify its text: TRACEON(8765) order allows valid beside the assemblage results of fluctuating length returned by C/ODBC operator. If we don't use this order - we can't haul the results from Navision tables - we will get errors, suchlike this:
OLE DB inappropriateness flavour [Non-interface error: Unexpected information fundamental measure returned for the column: ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'].
Server: Msg 7347, Level 16, State 1, Line 1
OLE DB bourgeois 'MSDASQL' returned an unanticipated facts fundamental quantity for the fixed-length indian file '[MSDASQL].Ship_to_Filter'. The matter-of-course assemblage fundamental quantity is 250, piece the returned information fundamental measure is 1.
OPENQUERY authentication opens connected waiter and transfers its SQL command, and in its curve returns the effect set. To interview the rule style in this instruct in SQL Server Query Analyzer: EXEC NavisionSalesReport
5. Now - motorboat Crystal Reports, use middling Wizard, bring into being new OLE DB (ADO) tie next to our MS SQL 2000 Server and superior NavisionSalesReport regulation in the database. As the papers william claude dukenfield we can use Description, Quantity, Line_Amount and Discount_Amount william claude dukenfield. You can crew by term Name - this is consumer linguistic unit. Our report is now ready!
Happy customizing, implementing and modifying! If you poverty us to do the job - provide us a telephone call 1-866-528-0577 or 1-630-961-5918!