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: Open-Source Software Is in Crisis IEEE Spectrum AV Unveils Advanced Software Updates to Enhance Puma UAS Capabilities in Contested Environments Yahoo Finance London startup Agemo has exited stealth. Now, it's building AI reasoning for software to take on Poolside and Magic. Business Insider Anduril Lattice Software Enhances US CENTCOM Air Defense Exercise The Defense Post The Generative Software Cycle is Here: OutSystems Introduces the Power of Low-Code x AI Business Wire Siemens and Microsoft bring AI-enhanced NX X to Azure for advanced product engineering Siemens Digital Industries Software Newsroom DOD taps ‘integrated software enablers’ to help fully realize ambitious Replicator plans DefenseScoop TestSprite nabs $1.5M to build autonomous AI software testing platform SiliconANGLE News Enterprise Software in the Age of Generative AI GP Bullhound Take-Two Interactive Software Chief Financial Officer Lainie Goldstein Sells 35% Of Holding Simply Wall St Schrödinger Announces Multi-Target Collaboration and Expanded Software Licensing Agreement with Novartis Business Wire Eversource Energy adopts new smart grid software to speed up interconnection study POWERGRID International®️ Joget Earns GovStack Software Requirements Compliance ENGINEERING.com Cloudsmith launches Enterprise Policy Manager for software supply chain SecurityInfoWatch KIC Launches Game-Changing TAS Software Platform to Address Emerging Thermal Process Challenges AZoRobotics New software package helps scientists analyze greenhouse gas levels in static chamber experiments Phys.org Danfoss Power Solutions launches ACL 3.2 software Industrial Vehicle Technology International Digital Watermarking Sortation Software From: Digimarc Corp. Packaging World Sonatype recognized as a leader in SCA software in Forrester Wave Security Boulevard AV Unveils Advanced Software Updates to Enhance Puma UAS Capabilities in Contested Environments Bluefield Daily Telegraph Office Hours With Professor Robert Kabacoff: Software Development, Finding Love Through Music, and Remembering the Early Internet Wesleyan Argus Snyk founder Guy Podjarny raises $125m for AI software development platform Tessl UKTN (UK Technology News Software Development Goes Full Brown Shirt On 3D Printing The Truth About Guns Forrester recognizes Black Duck as a Leader in software composition analysis Security Boulevard Montclair Council Passes Cell-Tower Ordinance, Tables Storm Water Regulation and Software Agreement TAPinto.net New PTV truck route-planning software version launched Traffic Technology Today Partsol Secures $17.5 Million in Capital to Expand Cognitive AI Software and Infrastructure PR Newswire AV Unveils Advanced Software Updates to Enhance Puma UAS Capabilities in Contested Environments Silicon UK From self-driving cars to AI that writes enterprise software: Cogna founder raises $15M - TechCrunch Managed File Transfer Software Market Next Big Thing: Major Giants TIBCO, OpenText, Citrix, Cleo EIN News Skeletons in the Closet: Legacy Software, Novel Exploits Security Boulevard Black Duck Honoured as a Leading Provider in Software Composition Analysis by Top Research Firm IT Security Guru Snyk founder’s Tessl raises $125M to revolutionise AI native software creation with spec-centric model Tech Funding News Danfoss software enables autonomous control Power Progress Pender Ventures closes second B2B software, healthtech-focused VC fund at $100 million BetaKit - Canadian Startup News Text Editor Software Market to Witness Excellent Revenue Growth Owing to Rapid Increase in Demand openPR Anti-money Laundering Software Market to Witness Massive Growth with Fiserv, Opentext, EastNets openPR News of Firms: AI-Based Software Dazzle Launches O'Dwyer's PR News CISA’s secure software deployment push: Key takeaways for AppSec teams 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 |