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

The Register

Fruit of an acquisition: Apple AI software goes open
The Register
Apple's joined other juggernauts of the tech sector by releasing an open source AI framework. Turi Create 4.0, which landed at GitHub recently, is a fruit of its 2016 US$200 million acquisition of Turi. As the GitHub description explains, it targets ...


Big Think (blog)

New DNA-Scanning Software Can ID You in Minutes
Big Think (blog)
Imagine a security system, say a key card scanner, an airport security checkpoint, or a pass code based on your DNA. That'd be really hard to hack. It sounds like science fiction. But researchers at Columbia University, along with colleagues at the New ...


PCWorld

The best free video editing software: Great tools for YouTube ...
PCWorld
The best free video editing software can be surprisingly good. The choices vary widely and include include scaled-down, trial versions of professional suites, open-source alternatives with a plethora of features, and simple applications aimed at home ...
Video Editing Software Developer Avid to Offer Remote ... - CTechCTech

all 2 news articles »

GeekWire

Tempered Networks raises another $7M for 'identity-defined networking' cybersecurity software
GeekWire
Founded in 2014, Tempered Networks originally focused on IoT security, but today its flagship product is networking infrastructure software that also acts as a layer of security. Its point-and-click “identity-based networking” architecture is based on ...

and more »

20 Constants In Software Development
HuffPost
If you have more than one developer worth their salt then you will always have disagreement about something. Everyone wants good documentation of code but no one budgets for it. The more high performing a team the more annoyed team members get about ...


Naked Security

Mailsploit: using emails to attack mail software
Naked Security
The most basic tenet of secure programming is this: don't trust anything you're planning to consume. Why? Because computer programs consume things from the outside world – like files, cookies, voice commands, passwords and a multitude of other data ...


Medical News Today

Could this software diagnose fetal alcohol spectrum disorders?
Medical News Today
Identifying certain types of alcohol-related neurodevelopmental disorder has proven challenging, but a new approach using a computer-based facial analysis tool may prove useful. Facial recognition software. A new study brings facial recognition ...


512tech.com

Planview expands its software offerings with another acquisition
512tech.com
Austin software maker Planview is expanding its project management offerings with the acquisition of a Tennessee-based company, the company said Monday. Financial terms of the deal were not disclosed. Planview sells software that helps companies map ...

and more »

RT

Hundreds of HP laptop models found to have hidden keylogging software
RT
HP says neither the company nor Synaptics had access to the files, and that it was built into the Synaptics software to help debug errors. "HP uses Synaptics' touchpads in some of its mobile PCs and has worked with Synaptics to provide fixes to their ...
Hidden software on HP laptops discovered that tracks what you typeDigitalSpy.com
HP laptops found to have hidden keyloggerBBC News
KEYLOGGING IN HP LAPTOPSDaily Mail

all 88 news articles »

KOAM-TV

New Software for Emergency Responders Coming to Newton County
KOAM-TV
"Instead of us trying to relay everything over the phone or radio, it'll be automatically in front of them," says Jennings. All of this technology centers around making sure keeping emergency responders safe never gets outdated. This new software will ...

and more »
Google News

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Start Developing Your Own Software

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

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... Read More

Can You Calculate Complex Financial Calculations?

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

Benefits of Integrating Online Chat Software with CRM

Customer Relationship Management (CRM) is a strategy and processes used... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

Microsoft CRM ? Typical Customizations

Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More