[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 514
  • Last Modified:

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
                                           
0
hums
Asked:
hums
  • 5
  • 4
  • 2
1 Solution
 
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
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
 
humsAuthor 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now