How to use MS Dynamics NAV 2009 database in Crystal reports

Chowdary

Hi Navisionfamily

I have been to many articles to find how to use MS Dynamics NAV 2009 database in Crystal reports and found some older version of Navision and SQL Server 2000 example as follows:
1. Create System DSN in ODBC
2. Create Stored procedure in SQL Server
3. Open Crystal Report and connect to NAV database through SQL Server
as explained in this link
http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/Navision-Attain-Customization.htm

Does anyone has procedure to do the same in MS Dynamics 2009 R2 and SQL Server 2008 Management Studio ?

Basically I'm looking for:
1. How to use Navision data in Crystal Reports ?
2. How to use Crystal Reports in Navision (C/SIDE) ?

Thanks in advance

rhpnt

Chowdary wrote:

1. How to use Navision data in Crystal Reports ?

As you would any other third party tool which queries the SQL database of an ERP system.

Chowdary wrote:

2. How to use Crystal Reports in Navision (C/SIDE) ?

You can't. Upgrade to NAV2009 and use Visual Studio to create stunning reports for the RTC which are on par with Crystal Reports.

Chowdary

A straight reply, that I would like to know

thanks a lot