Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Navision Attain C/ODBC Crystal Report ? Customization Example > NetSparsh - Viral Content you Love & Share

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
GO

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 1 OLE 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 NavisionSalesReport 5. 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! [email protected]

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.

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Forbes

The Best Tax Software
Forbes
Our budget pick, TaxAct Tax Software, is a great alternative. However, it's less intuitive and is geared toward those who already have a good working knowledge of filing taxes. Although it's less expensive, this pick offers solid security and is a ...


Ars Technica

Daimler included emissions-cheating software on diesels, German ...
Ars Technica
US investigators are looking into whether Mercedes parent company Daimler used illegal software to cheat emissions tests on diesel vehicles in the US, according to German newspaper Bild am Sonntag, whose report was picked up by Reuters. Though the ...
Daimler Drops on Report Software Affected US Emissions TestsBloomberg
Daimler may have used software to cheat on US emissions testsEngadget
Software may have helped Daimler pass US emissions tests: reportReuters
Nasdaq -Arab News -Autoblog (blog)
all 26 news articles »

Los Angeles Times

Toyota Prius software fix may reduce fuel efficiency, experts say
Los Angeles Times
Assertions that the Toyota software change decreased the car's fuel economy are contained in a lawsuit seeking class-action status filed this month in U.S. District Court in Los Angeles. "Unbeknownst to drivers, Toyota reduced the vehicles' fuel ...


Global Hotel and Hospitality Management Software Market Will Reach USD 4300 million by 2022: Zion Market Research
GlobeNewswire (press release)
19, 2018 (GLOBE NEWSWIRE) -- Zion Market Research has published a new report titled “Hotel and Hospitality Management Software Market By Hotel Type (Business Hotels, Heritage and Boutique Hotels, and Resorts and Spas); By Type (Hotel Operation ...

and more »

Automotive News (blog)

Software helping dealers manage loaners
Automotive News (blog)
Effective fleet management enables service departments to monitor costs and improve customer satisfaction, says Gary Juffre, business development director of TSD, a supplier of software for dealership loaner fleets. "To take it lightly hurts customer ...


3D Printing Industry

Grafter 3D software lets you remix and 3D print working mechanical parts
3D Printing Industry
The Hasso Plattner Institut (HPI), a design, digital and engineering institute at the University of Potsdam has developed the Grafter 3D software system, which allows users to remix 3D models machines and create working mechanisms that can be 3D ...


Automotive News (blog)

Remote software updates help build service business, suppliers say
Automotive News (blog)
Few capabilities for over-the-air software updates may have a side benefit that could help dealerships retain service business. Nunneley: Guide owners to service. In addition to performing updates remotely, new systems about to reach the market can ...


QPR Delivers Process Mining Software to Piraeus Bank
GlobeNewswire (press release)
The software also offers the possibility to proactively reduce and avoid process exceptions with artificial intelligence. “This wonderful new deal proves that QPR is the leading player in process mining market. We are thrilled to work together with ...

and more »

Plastics Technology

New Software Collaborations Advance CAD for 3D Printing
Plastics Technology
Two software collaborations were announced last month to make possible more powerful computer-aided design of 3D-printed parts. One partner in both collaborations is Dassault Systèmes' SolidWorks CAD platform, Waltham, Mass.Dassault agreed last month ...


Texas A&M The Battalion

TAMU Make focuses on hardware rather than software creation
Texas A&M The Battalion
The idea was to stand out from most hackathons that involve software and have this event centered around hardware hacks. The participants were successful in realizing many concepts and created working hardware models, including an automatic bartender ...

Google News

Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

Inherent Dangers Of File Sharing Via The Internet.

Cyberspace has opened up a new frontier with exciting possibilities... Read More

Microsoft Great Plains Integrations - Tips for Developer

In this short FAQ style article we would like to... Read More

Microsoft Great Plains Data Conversion ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

Simple Solution for Php Includes - IFrames

I have recently created my first Php program. I wanted... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More