Solved

FoxPro dataset and Crystal reports 2008

Posted on 2009-05-15
11
508 Views
Last Modified: 2012-05-07
Can Crystal Reports 2008 open Foxpro 9.x Datasets ? I am trying to open a dataset so I can develop a new Crystal Report but it keeps asking for a 'User name' and 'Password'.

                                                         Thanks,
                                                         Bob H
                                           
0
Comment
Question by:hums
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 24399469
If your FoxPro data are in the folder which is accessible without password for you then FoxPro should not ask. Some small possibility is a FoxPro database event which asks for the password - you could partly recognize it by existence of .DBC file in data folder.

ANother problem could caused by fact that not all the newest FoxPro data types are supported by ODBC and ADO.

BTW, why not to use Visual FoxPro 9 report writer? It is easier and more user friendly than Crystal. You should try to open data tables in Visual FoxPro at least.
0
 

Author Comment

by:hums
ID: 24399543
The FoxPro database is from a third product that uses Crystal Reports for the report writter. I will give the .DBC file a try. The FoxPro data is in a sepeate directory.

                                                                                                       Thanks,
                                                                                                        Bob H
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24399619
Another possibility would to copy .DBF, .FPT, and .CDX files of your interest to another folder and create the report on this copy.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Author Comment

by:hums
ID: 24413042
I tried to copy the  .FPT, and .CDX files and run the report from the same directory without sucess. The only *.cdx I see on the system are Datadict.cdx and DDnames.cdx. May be the reports that work are somehow run through the products data dictionary. Also I 'googled' the error message and it might be a problem with xbase type databases and Crystal Reports 2008. Anyway I will post the solution when I figure out what is wrong.

                                                                             Thanks for the info,
                                                                             Bob H
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24413264
.DBFs are data, .FPTs are memo fields, and CDXes are indexes. If there are almost no indexes is not obvious but possible.

It is not so easy to open these files without Visual FoxPro installed (and it is not easy to me investigate the problem without Crystal installed :-).

I'll appreciate if you write your further observations here. Thanks.
0
 

Author Comment

by:hums
ID: 24455535
The answer that was given to us is that the RDC (COM) object is no longer support or shipped with  2008. The RDC was how the 3rd party software was hooked into FoxPro and Crystal Reports. This may be the case and there may not be a work around. All of the required *.dll's are installed on my work station so I am not going to give up yet. I think there still may be a work around to hook into the FoxPro dataset. 2008 Crystal Reports  is not going to set up any COM object type interfaces as people are used to.

                                                                                 Bob H

                                                                                                           

                                                                     
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24455611
It seems, you are right - http://www.craigberntson.com/blog/2007/11/crystal-reports-2008-dont-bother.asp

I would propose to access data via ODBC driver. It is rather independent on the data source and everything you need is VFP ODBC driver and connection string.

This article confirms it: http://www.ml-consult.co.uk/foxst-19.htm

Some additional infor is here: http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_21769827.html

So, th equestion is: Do you really need all new features of Crystal 2008?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24455649
The official Crystal/SAP line.  You are correct the RDC was dropped for CR2008.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80bd35e5-c71d-2b10-4593-d09907d95289

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24456374
According to this article Foxpro is not a supported database unless you can get database driver from Foxpro.
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f05523e4-35c4-2b10-2c89-9fcf64b0dd22

mlmcc
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24459349
According to above document FoxPro and many more other data sources can be accessed via ODBC driver.
0
 

Accepted Solution

by:
hums earned 0 total points
ID: 24506909
Final Comment - I could not figure out a way to attach the FoxPro dataset from the 'AUS CIS' product so the only solution I could think of was to switch back to Crystal Report XI.  
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question