Software Information |
|
Navision Attain C/ODBC Crystal Report - Customization Example
Microsoft Business Solutions Navision is main ERP application for European, Brazilian markets plus it serves vertical segments of the USA market, such as light manufacturing, POS, CRM. As our experience indicates - Navision implementation requires more customization and tuning in comparison to another mid-market ERP solution from MBS: Microsoft Great Plains. Our goal is to popularize Microsoft Business Solutions products and enlighten IT people to do customize Navision in-house. Today, the main topic of this article is working with native C/SIDE Navision Attain database via C/ODBC interface, in particular - Linked Server creation in Microsoft SQL Server 2000 environment and then Sales report design in Crystal Reports ver. 10. Let's begin: 1. We will use Navision Attain 3.6 with Navision Database Server, Navision ApplicationServer and Navision Client. These component are installed on Windows XP Professional. To enable C/ODBC interface you need to install this component from Navision Attain CD. 2. Let's create ODBC DSN for connection to Navision database: Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC), then switch to System DSN and click Add. We will use C/ODBC 32-bit driver. Give Data Source Name Navision, Connection - leave it Local. As the database (Database button) select Program FilesNavision AttainClientdatabase.fdb (this is demo DB). Then press Company button - in our case we use CRONUS demo database. Important conditions to provide proper connection with C/SIDE database are correct options for C/ODBC. Click Options button and look at the options available - we will pay attention to Identifiers screen - this is where you setup identifiers to be transferred to client application. We will use these types: "a-z,A-Z,0-9,_" to make MS SQL Server 2000 work correct with C/ODBC source. We are now done with ODBC DSN. Lets setup Linked Server 3. Open SQL Server Enterprise Manager. Open object browser on the left side, select Security and Linked Servers. With right click select New Linked Server in the context menu. In the emerging dialog window, in the menu Provider Name select Microsoft OLE DB Provider for ODBC Drivers. Let's name our Linked Server as NAVISION. In the Data Source string type in ODBC DSN name - NAVISION in our case. Linked Server is ready. Select tables list and we now see Navision Attain tables.4. Now we need to create small procedure for Sales data extraction. Here is the text of the procedure:CREATE PROCEDURE NavisionSalesReport AS DBCC TRACEON(8765) SELECT * FROM OPENQUERY(NAVISION, 'SELECT * FROM Sales_Line sls, Customer cust WHERE sls.Sell_to_Customer_No_ = cust.No_') RETURN To clarify its text: TRACEON(8765) directive allows working with the data results of variable length returned by C/ODBC driver. If we don't use this directive - we can't pull the results from Navision tables - we will get errors, like this: OLE DB error trace [Non-interface error: Unexpected data length returned for the column: ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'].Server: Msg 7347, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].Ship_to_Filter'. The expected data length is 250, while the returned data length is 1. OPENQUERY statement opens linked server and transfers its SQL command, and in its turn returns the result set. To test the procedure type in this command in SQL Server Query Analyzer: EXEC NavisionSalesReport5. Now - launch Crystal Reports, use standard Wizard, create new OLE DB (ADO) connection with our MS SQL 2000 Server and select NavisionSalesReport procedure in the list. As the report fields we can use Description, Quantity, Line_Amount and Discount_Amount fields. You can group by name Name - this is customer name. Our report is now ready!Happy customizing, implementing and modifying! If you want us to do the job - give us a call 1-866-528-0577 or 1-630-961-5918! help@albaspectrum.com Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Moscow, Europe and internationally (http://www.albaspectrum.com), he is Microsoft CRM SDK, Navision, C#, VB.Net, SQL, Oracle, Unix developer.
MORE RESOURCES: Asure Software Inc (ASUR) Q1 2024 Earnings Analysis: Mixed Results Amidst Revenue Growth and ... Yahoo Finance Guesty, Short-Term Rental Software Provider, Acquires Rentals United Skift Travel News CISA urges software devs to weed out path traversal vulnerabilities BleepingComputer Rocket Software Buys OpenText's App Modernization & Connectivity Business for $2.3B; Milan Shetti Quoted GovCon Wire City to roll out new financial payment software system Hastings Star Gazette Upland Software (UPLD) Tops Q1 EPS by 2c ; Offers Guidance StreetInsider.com GDDY: Top Software Stock May Watchlists StockNews.com Autire's Revolutionary EBP Audit Software Demonstrates Significant Time Savings for CPA Firms PR Newswire Epicor Acquires Smart Software for AI-Powered Inventory Planning - Supply and Demand Chain Executive Epicor Acquires Smart Software for AI-Powered Inventory Planning Supply and Demand Chain Executive Durst Announces 1,000th Installation Of Durst Workflow Software | Label and Narrow Web Label & Narrow Web Exclusive: IBM brings its AI, data and automation software to AWS Marketplace in 92 countries VentureBeat IBM Expands Software Availability in AWS Marketplace Channel Futures Tesla Cybertruck gains Off-Road modes, locker-enabling software Motor Authority Using my speech issues to improve voice recognition software ALS News Today Best video conferencing software of 2024 TechRadar GlobalLogic Recognized as Leader in Everest Group's Software Product Engineering Services Business Wire How Software Composition Analysis (SCA) Addresses President Biden’s Executive Order (EO) 14028 Security Boulevard Auto Dealership CRM Software: Global Market Analysis and Forecast (2018-2033) by Type, Functionality, Application ... Yahoo Finance Verizon 2024 DBIR: Software supply chain risks fuel a data breach epidemic Security Boulevard Marin Software Announces First Quarter 2024 Financial Results Daily Host News The power of the power pose: How a software CEO became a better leader Business Observer Best Fax Server Software 2024 | IBTimes International Business Times Update from eSync Alliance accelerates software-defined vehicle roadmap ComputerWeekly.com Investors in Take-Two Interactive Software (NASDAQ:TTWO) have seen decent returns of 40% over the past five years Yahoo Finance Ford’s BlueCruise software probed after fatal crashes just-auto.com Paycom Software (PAYC) Q1 2024 Earnings Call Transcript The Motley Fool How patient engagement software can enhance oncology care Health Data Management DeepSea Developments Modularizes the RTL-SDR for Multi-Receiver Software-Defined Radio Projects Hackster.io CyberArk Shares Slide Despite Positive Outlook, Earnings Report - CyberArk Software (NASDAQ:CYBR) Benzinga Supply Chain Management Software: Build the foundation, deliver the value Logistics Management Software Developer SolarWinds Stock Shines After Q1 Earnings - Here's Why - SolarWinds (NYSE:SWI) Benzinga 2024.14.3 Official Tesla Release Notes - Software Updates Not a Tesla App Wyoming Senator Slams DOJ's Take on Non-Custodial Crypto Software, Vows to Protect User Rights – Bitcoin News Bitcoin.com News IBM Expands Software Availability to 92 Countries in AWS Marketplace The Globe and Mail Top ideas in vertical software with valuations over or below 50th percentile - Baird - Seeking Alpha V-22 Evolving into 'Software-Defined' Platform National Defense Magazine 30 Largest Software Companies in the World by Market Cap Yahoo Finance NVIDIA Buys Software Provider Run:AI Silicon Valley Daily Paycom Software Inc (PAYC) Q1 2024 Earnings Call Transcript Highlights: Robust Growth and Strategic Expansions GuruFocus.com Carnival Corporation completes fleetwide software rollout Port Technology International Epicor acquires Smart Software Edge Middle East Boeing Advances US Navy MUM-T Aerial Refueling Software With Digital F/A-18 Super Hornet & MQ-25 Stingray Trial Simple Flying USENIX Security ’23 – “My Privacy for their Security”: Employees’ Privacy Perspec... Security Boulevard |
RELATED ARTICLES
How to Backup Windows XP Home Edition Your computer cost you from hundreds to thousands of dollars, but the computer itself is not the most valuable part. The data on the hard disk is the most valuable part. Microsoft Great Plains SOP: Sales Order Processing Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Sales Order Processing (SOP) module forms a third of the core Inventory and Order Processing part of Great Plains. CRM 101: Customer Relationship Management for Beginners Customer Relationship Management, abbreviated "CRM," is the term for a business strategy that is designed to improve customer service. CRM is also designed to increase customer satisfaction and gain new customers, thus increasing a business' revenue. Configure Windows Indexing Service for Performance The Windows Indexing Service provides you with the ability to perform advanced searches on directories located on your computer and on shared directories on the network. The Indexing Service was introduced with IIS (Internet Information Services) and is now installed with Windows 2000 and Windows XP. An Easy Way to Develop JAVA Enterprise Applications Research bears that less than 70 percent of development projects are actually completed, and more than half come in late and over budget. AlachiSoft TierDeveloper is a Rapid Application Development tool that helps Software Developers do better, more creative, and useful work by reducing redundant hand coding. Microsoft Great Plains Beverage Production & Distribution - Implementation & Customization Highlight Microsoft Business Solutions Great Plains has many years of successful implementation in multiple horizontal markets. In today's small article we'll share our experience of implementing and customizing Microsoft Great Plains, formerly Great Plains eEnterprise/Dynamics in beverage production and distribution industries. Separate Anti-Keylogging Protection: Who Needs it Most? If there still are few unprotected computers left, I haven't seen any.Every emerging threat causes means of defense to appear. Great Plains Sales Order Processing and Invoicing Modules - Tips For Consultants We'll give you non formal view, based on our consulting practice.Common Features. SQL scripts for Project Accounting: Microsoft Great Plains series - overview for developer Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB Admin touches. Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting In order to meet regulatory and corporate compliance requirements reporting members will require a cost effective solution that may be installed at one side of the data transfer without being tied to any proprietary protocol.Considerations include:- is it designed for use in most enterprise environments?- is it flexible & adaptable to suit an unlimited range of needs for secure file transfer internally and externally? Functionality and benefits should include:+ can easily be adapted+ Automatic transfer to single or multiple destinations of any file. Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair - Overview For DBAs 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. ERP for Large Corporation - New Selling Strategy Our opinion is based on our Microsoft Business Solutions Great Plains, Microsoft CRM sales and marketing campaign to large businesses in the following industries: Aerospace, Furniture, Beverages, Placement, Distribution & Logistics, Textile, Services, Food, Manufacturing. With the new economy recovery we see signs on the market, signaling selling strategy change. Oracle Development: JDeveloper 10G - Java, J2EE, EJB, MVC, XML - Overview For Programmer In 2004 Oracle, Inc. made its new step toward J2EE application development simplification, releasing new RAD Oracle JDeveloper 10G. Microsoft Great Plains international implementation - USA / Mexico - overview for consultant Microsoft Business Solutions Great Plains was purchased from Great Plains Software and Great Plains Software itself had strong international marketing plans and campaigns. If we look back to 1990th - we'll see that GPS had Multilanguage support and Great Plains Dynamics / Dynamics C/S+ was localized and translated into multiple languages, including Spanish. Microsoft CRM Data Import FAQ 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 might never use and need. Who's Watching What You Type? If someone entered your home, uninvited and installed numerous cameras and listening devices in order to monitor your activities, you would quite rightly be outraged. While such a situation, unless you are living in the Big Brother House, would be considered ridiculous, the same cannot be said for the humble home computer. Five Tips For A Great Software Demo Whether you need to close a sale, gather end-user feedback, show progress to your customer, or simply explain how your product works, sooner or later, you will need to demo your software product.Over the years, I've had the opportunity to perform hundreds of demos to audiences of various sizes. HelpDesk & Asset Management Software - Choosing The Right One If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole). How To Identify, Cure and Prevent Spyware/Adware Infections Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use. Start Developing Your Own Software Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think. |
home | site map |
© 2006 |