Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

FoxPro dataset and Crystal reports 2008

Posted on 2009-05-15
11
Medium Priority
?
513 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
  • 5
  • 4
  • 2
11 Comments
 
LVL 43

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 43

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 43

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 43

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 101

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 101

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 43

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

886 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