FoxPro dataset and Crystal reports 2008

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
                                           
humsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
humsConnect With a Mentor Author Commented:
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
 
pcelbaCommented:
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
 
humsAuthor Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
pcelbaCommented:
Another possibility would to copy .DBF, .FPT, and .CDX files of your interest to another folder and create the report on this copy.
0
 
humsAuthor Commented:
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
 
pcelbaCommented:
.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
 
humsAuthor Commented:
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
 
pcelbaCommented:
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
 
mlmccCommented:
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
 
mlmccCommented:
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
 
pcelbaCommented:
According to above document FoxPro and many more other data sources can be accessed via ODBC driver.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.